rwhite0823
New Member
- Joined
- Dec 20, 2017
- Messages
- 7
I need help on how to take one column with an address and make it into multiple columns without using the Text to Columns method.
My example address looks like this:
<tbody>
</tbody>
After I copy and paste that into a multiple column cell, I would like to have it in 4 columns going across:
2000 STREET ADDRESS DR CITY STATE 20000
I know there is the left, mid and right functions but I don't know how to do what I need. I would appreciate help.
My example address looks like this:
2000 STREET ADDRESS DR CITY, STATE 20000 |
<tbody>
</tbody>
After I copy and paste that into a multiple column cell, I would like to have it in 4 columns going across:
2000 STREET ADDRESS DR CITY STATE 20000
I know there is the left, mid and right functions but I don't know how to do what I need. I would appreciate help.