LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SJS SJS is offline
external usenet poster
 
Posts: 20
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Extract data to the right of the last comma in a cell Huber57 Excel Discussion (Misc queries) 3 January 13th 09 01:32 PM
how do I extract only certain data from a cell? Stan in South Africa Excel Discussion (Misc queries) 6 July 6th 08 08:44 PM
Extract data from a cell reference Fanny Excel Discussion (Misc queries) 5 March 7th 07 12:42 PM
How do I extract data from every other cell in a colomn? Spencer Christensen Excel Worksheet Functions 1 March 31st 06 08:12 AM
extract data from a realtime updated cell ALVESM Excel Discussion (Misc queries) 4 March 21st 05 05:21 PM


All times are GMT +1. The time now is 04:36 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"