Extract data from a cell

  • Thread starter Thread starter sjs
  • Start date Start date
S

sjs

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
 
Hi,
Highlight the column, data, text to columns, delimiter, choose comma, Ok

if this helps please click yes thanks
 
Perfect!! Thanks Eduardo and Glenn!!

Eduardo said:
Hi,
Highlight the column, data, text to columns, delimiter, choose comma, Ok

if this helps please click yes thanks
Click to expand...
 
Hi,

You may also use this

=LEFT(C18,SEARCH(",",C18)-1) for the names; and
=RIGHT(C18,LEN(C18)-SEARCH(",",C18)-1) for the address

The assumption herein is that the names and address are separated by commas
and that there is only one comma in the string

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
 
Back
Top