Are there any way to add text and a function in the same cell? For example Hello =sum(XX:XX)
D danne Aug 15, 2003 #1 Are there any way to add text and a function in the same cell? For example Hello =sum(XX:XX)
C Chip Pearson Aug 15, 2003 #2 Try something like ="Hello "&SUM(A1:A10) -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (e-mail address removed)
Try something like ="Hello "&SUM(A1:A10) -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (e-mail address removed)
M Max Aug 15, 2003 #3 Sure, for example: ="Hello = "&SUM(A1:B1) For more info, try MVP Debra Dalgleish's "Excel -- Combining Data" at: http://www.contextures.com/xlCombine01.html
Sure, for example: ="Hello = "&SUM(A1:B1) For more info, try MVP Debra Dalgleish's "Excel -- Combining Data" at: http://www.contextures.com/xlCombine01.html
