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
drelingerAsked:
Who is Participating?
 
Glenn RayExcel VBA DeveloperCommented:
Insert these formulas and copy down:

B2:  =LEFT(A2,10-LEN(C2))
C2:  =VALUE(LEFT(A2,10))
D2:  =RIGHT(A2,5)

Regards,
-Glenn
0
 
drelingerAuthor Commented:
wow - impressive and cool.  Thank you for teaching me that. Regards.
0
 
Glenn RayExcel VBA DeveloperCommented:
You're Welcome.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.