Pull Data Formula

KhodrK1590

New member
Joined
Oct 18, 2021
Messages
6
Reaction score
0
Points
0
Excel Version(s)
2021
Hello,

I have a column with cost center numbers that are like this:

76701000VT91549009


I want to make a new column where I pull only the last TEN numbers of the column, let's say COLUMN H is those numbers, and COLUMN I is where I want
VT91549009

What would be the formula to do this?
 
Say your first cell containing data is A1, use this in B1 copied down:

=RIGHT(A1,10)
 
Back
Top