Amanda Walshaw
asked on
splitting up a field into two columns
I have this column that needs to be split into two columns
GA01000142
VA06000035
VA06000261
VA06000265
Column 1
GA0
Column 2
1000142
The column consitential has a two letter prefix with a 0, how can you do it.
GA01000142
VA06000035
VA06000261
VA06000265
Column 1
GA0
Column 2
1000142
The column consitential has a two letter prefix with a 0, how can you do it.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.