jo15765
Well-known Member
- Joined
- Sep 23, 2011
- Messages
- 591
I have data that is set-up like this and i am needing to split it into individual columns
Hallway Oats & Freeform 2212 Blue Ridge Lane Redfren, SC 99121
Name = Hallway Oats & Freeform
Address = 2212 Blue Ridge Lane
City = Redfren
State = SC
Zip = 99121
What syntax would split this data into individual cells? (Note, not all the Names have a & in them some of them do not so that is not a good way to split the data)
Hallway Oats & Freeform 2212 Blue Ridge Lane Redfren, SC 99121
Name = Hallway Oats & Freeform
Address = 2212 Blue Ridge Lane
City = Redfren
State = SC
Zip = 99121
What syntax would split this data into individual cells? (Note, not all the Names have a & in them some of them do not so that is not a good way to split the data)