View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
N Harkawat N Harkawat is offline
external usenet poster
 
Posts: 55
Default 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?