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:
[TABLE="width: 216"]
<tbody>[TR]
[TD="class: xl65, width: 216"]2000 STREET ADDRESS DR
CITY, STATE 20000[/TD]
[/TR]
</tbody>[/TABLE]
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:
[TABLE="width: 216"]
<tbody>[TR]
[TD="class: xl65, width: 216"]2000 STREET ADDRESS DR
CITY, STATE 20000[/TD]
[/TR]
</tbody>[/TABLE]
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.