ST Alpha - "ST is best tech support: Excel: I have a spreadsheet full of addresses, but would like to split the address line into two (house number/street name)." (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Login
Create Account

Search Dr. S. Talk
TT/ST Wiki
How Well Do You Know ...

RSS Feed

Hosting by DigitalOcean

Support ST on Ko-Fi

Down to Post

Backboards:

Posts: 154

ST is best tech support: Excel: I have a spreadsheet full of addresses, but would like to split the address line into two (house number/street name).

Posted by Name Withheld By Request (aka BlueKopo) Jul 31 '14, 10:06

How do I go about doing that?

Responses:

If the format of them all is "1234 main st.", you can do the following to make sure you don't get spaces - JaxSean Jul 31, 10:20 1
- Thanks gang over here. This is what I was needing... -- nm - Name Withheld By Request Jul 31, 10:31
highlight column. data --> text to columns --> use space as delimter -- nm - peggy ann m Jul 31, 10:09 3
- but then it splits on every space, including between Main and St., etc. If you just want to split at the first space ... - zork Jul 31, 10:19 1
  - You can select those columns and concatenate them back -- nm - Roger More Jul 31, 10:26
- You are a peach. -- nm - Name Withheld By Request Jul 31, 10:18

Post a message top

Replies are disabled on threads older than 7 days.