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/222289-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?

N Harkawat

split cell data?

you mean some formula like this

="Some text"&sum(a1:a100)&" some more text"

"mome" wrote:

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 02:57 AM.