Splitting large quantity of cells in a column (over 6000)

ljoudai

New member
Joined
Dec 28, 2012
Messages
1
Reaction score
0
Points
0
So here's my problem. I need to split cells that contain addresses in them into different categories, street address, city, state, zip. The problem is that each of these cells contains the name of each company as well and also some cities are 2 words as opposed to 1, I've tried converting to text, but that doesn't seem to help me with this problem. Someone please help or I'll be doing this manually for the next couple of months. Thanks.
 

Ken Puls

Administrator
Staff member
Joined
Mar 13, 2011
Messages
2,520
Reaction score
5
Points
38
Location
Nanaimo, BC, Canada
Website
www.excelguru.ca
Excel Version(s)
Excel Office 365 Insider
Can you attach a workbook with some sample data we can look at? Make sure it doesn't contain any confidential info, but that would help us establish a pattern to look through and built a method to split it. (Click Go Advanced at the bottom of the post to add a workbook.)
 
Top