LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 331
Default split one column to multiple columns

I have data formatted in column A like:

Sheldon Barnes ,
Miriam DURVAMC Mil34ler ,
Eddie Barnes ,
Deloris Bell-Johnson ,
Brenda Bethea ,
jessie bowen ,

How can i separate into three columns?
First Name, Last Name, E-mail

Many Thanks in Advance
Greg
 
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
split one column into multiple columns SandyDi Excel Discussion (Misc queries) 2 September 25th 09 12:34 AM
split 1 column to 3 columns rckymtntim Excel Discussion (Misc queries) 2 January 7th 08 12:21 AM
How to split columns with multiple lines w/in cells Ben Excel Discussion (Misc queries) 2 May 30th 07 03:52 PM
How do I split a cell into multiple rows/columns? SKA Excel Discussion (Misc queries) 1 January 18th 06 12:04 AM
split column into 4 columns Jack Excel Discussion (Misc queries) 3 November 15th 05 08:27 PM


All times are GMT +1. The time now is 01:23 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"