View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Glenn Glenn is offline
external usenet poster
 
Posts: 1,240
Default Extract data from a cell

sjs wrote:
I have a cell that contains two pieces of data separated by a comma (ex:
first name, address). I'd like to extract the data into two cells so that
the first name is in one cell and address is in a second cell.

Any help would be greatly appreciated!

tks,
steve


You could try Data / Text to Columns.

http://blog.contextures.com/archives...ames-in-excel/