Hi: Can I split a cell with text, then a formula, then with more text? If so how?
M mome Feb 25, 2009 #1 Hi: Can I split a cell with text, then a formula, then with more text? If so how?
R Ron Rosenfeld Feb 25, 2009 #2 Hi: Can I split a cell with text, then a formula, then with more text? If so how? Click to expand... Please post an example of the original cell content, what you want as output, and where you want the output stored. --ron
Hi: Can I split a cell with text, then a formula, then with more text? If so how? Click to expand... Please post an example of the original cell content, what you want as output, and where you want the output stored. --ron
T T. Valko Feb 25, 2009 #3 Follow this general syntax: ="Text "&FORMULA&" text" For example: ="Today is day "&DAY(NOW())&" of the month" Returns: Today is day 25 of the month
Follow this general syntax: ="Text "&FORMULA&" text" For example: ="Today is day "&DAY(NOW())&" of the month" Returns: Today is day 25 of the month
