ExcelBanter - split cell data?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - split cell data? (https://www.excelbanter.com/excel-worksheet-functions/222288-split-cell-data.html)

mome

split cell data?

Hi:
Can I split a cell with text, then a formula, then with more text? If so how?

T. Valko

split cell data?

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

--
Biff
Microsoft Excel MVP

"mome" wrote in message
...
Hi:
Can I split a cell with text, then a formula, then with more text? If so
how?

All times are GMT +1. The time now is 03:12 PM.