MrExcel Publishing
Your One Stop for Excel Tips & Solutions

un-Merging columns


Posted by Beverley on January 18, 2002 9:06 AM

I have a column that reads STZIPCITY is there a way for me to split this into 3 columns, bear in mind that there are no spaces, comma's ect separating the information in these rows.


Posted by Juan Pablo G. on January 18, 2002 9:31 AM

Use Text To Columns, and choose fixed with in step 1. Then "draw" the divisions manually.

Juan Pablo G.