Tech Support Guy banner
Status
Not open for further replies.
1 - 2 of 2 Posts

·
Registered
Joined
·
217 Posts
Discussion Starter · #1 ·
I need to convert a csv file which the STREET field hes the
Street Number
Street Name
street type
All in the same field (see attacted sample) Column P,
I need the this field seperated into 3 seperate Columns
Street Number
Street Name
Street type

Anyone have any Idea how to do this???
 

Attachments

·
Registered
Joined
·
11,755 Posts
Probably won't be perfect, but will nearly get you there:

Insert a bunch (like 10) columns to the RIGHT of that column.
Select Column P.
From the menu, Data-->Text to columns
Choose Space as the delimiter
Ok.

Now before you go sorting any data, go put headers into those blank column headings (row 1). Then you can sort your little heart out to find idiosyncrasies and move some of the data into the proper columns. I'm sure you'll have stupid stuff like 192 La Jolla Drive, which will break into 4 columns instead of just 3...that's what you'll want to do. Put the headings in, then sort by 10th added column; first AZ then ZA sorts. Nothing there? Delete it. Sort by 9th. Nothing there? Delete it. And so on until you find one that does have some data, then you'll start seeing things like the two-part street name issue.
 
1 - 2 of 2 Posts
Status
Not open for further replies.
Top