lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
250 Main Street |
1000 Grand Street |
<tbody>
</tbody>
Hello
I am trying to use Text-to-Column command to separate street# from street name. I used Space as delimiter. But excel breaks the text into 3 columns, one for number and second for street name and third for the word "street". How can I use Text-To-Columns to separate the above address into 2 columns only like the following
A | B |
250 | Main street |
<tbody>
</tbody>
Thanks a lot.