Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / June 2006

Tip: Looking for answers? Try searching our database.

Separated data in one column to multiple columns

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
leenathan@gmail.com - 30 Jun 2006 18:31 GMT
Howdy Excel experts,

I have one big column of data, each chunk of values separated by a
space of blank cells.  I'd like to take all the data chunks and put
them each in their own column, beginning at the top of the worksheet.
Basically taking one long column of data and transforming it into a
shorter, wider worksheet.

I hope this makes sense.  Thanks for your help!
Bernard Liengme - 30 Jun 2006 19:26 GMT
Use Data | Text to Columns
best wishes

Signature

Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

> Howdy Excel experts,
>
[quoted text clipped - 5 lines]
>
> I hope this makes sense.  Thanks for your help!
Gord Dibben - 30 Jun 2006 21:00 GMT
Are all chunks the same number of rows?

Are the spaces between chunks uniform?

Gord Dibben  MS Excel MVP

>Use Data | Text to Columns
>best wishes
[quoted text clipped - 8 lines]
>>
>> I hope this makes sense.  Thanks for your help!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.