| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extract data from a cell
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Extract data from a cell
Hi,
Highlight the column, data, text to columns, delimiter, choose comma, Ok if this helps please click yes thanks "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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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/ |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Extract data from a cell
Perfect!! Thanks Eduardo and Glenn!!
"Eduardo" wrote: Hi, Highlight the column, data, text to columns, delimiter, choose comma, Ok if this helps please click yes thanks "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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Extract data from a cell
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 "sjs" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extract data to the right of the last comma in a cell | Excel Discussion (Misc queries) | |||
| how do I extract only certain data from a cell? | Excel Discussion (Misc queries) | |||
| Extract data from a cell reference | Excel Discussion (Misc queries) | |||
| How do I extract data from every other cell in a colomn? | Excel Worksheet Functions | |||
| extract data from a realtime updated cell | Excel Discussion (Misc queries) | |||
Linear Mode
