lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
Hi
I have a column which has text like following
123 main street CityName StateName 123456
I want to put street number, name, cityname, statename, postal code all in different columns. I know it is possible to use Text-to-Column but I was thinking about using functions/formulas in case the length is different (I know that wont effect text to column) but also if instead of space there is - or ; or ,.
Thanks a lot
I have a column which has text like following
123 main street CityName StateName 123456
I want to put street number, name, cityname, statename, postal code all in different columns. I know it is possible to use Text-to-Column but I was thinking about using functions/formulas in case the length is different (I know that wont effect text to column) but also if instead of space there is - or ; or ,.
Thanks a lot