Mark Drelinger
asked on
parse Excel TEXT field
I'm a bit under the gun here doing a system upgrade tonight.
I have a field (FullRecordKey) that contains a series of numbers (including mandatory leading zeros) that I need to parse into columns as follows:
Example
FullRecordKey Leading Account Record ID
000000933500001 000000 9335 00001
000004088200006 00000 40882 00006
C--Users-Drelinger.D179434-Desktop-Book1
I have a field (FullRecordKey) that contains a series of numbers (including mandatory leading zeros) that I need to parse into columns as follows:
Example
FullRecordKey Leading Account Record ID
000000933500001 000000 9335 00001
000004088200006 00000 40882 00006
C--Users-Drelinger.D179434-Desktop-Book1
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You're Welcome.
ASKER