Thread: functions
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Billigmeier
 
Posts: n/a
Default functions

<Data <Text to Columns...
Then, select "Delimited", hit next, and check Semi Colon


--
Regards,
Dave


"bsantona" wrote:

I have a large amount of text in one cell separated by a semi colon. I would
like to separate the data into several cells by semi colon.

Any help would be great.

Thanks