Text to column question

[JVS]

I have a spread sheet from a vendor, they have a column where the last 3
digits represents their job number and the balance of value represents my
job number.

I'd like to split their column so that I can have my job number in it's own
column.
Not sure how to do it since the total field could have any where form a
total of 4 to 7 digits. I tried the text to column but it appears to work
from left to right
and I wind up mixing my job no with part of their no.
xzzz
xxzzz
xxxzzz
xxxxzzz

Thanks!
Johnny

 

[John Wilson]

JVS,

If you're only looking for the rightmost three characters, this should work:

=RIGHT(A1,3)
Will extract the right three.

In another column:
=LEFT(A1,LEN(A1)-3)
Will extract all but the last three characters.

The above assumes that the characters you're trying to extract are in A1
(modify to suit). You can "copy down" as far as you need to for all of the
data in a specific column.

John

 

[JVS]

Exactly what I was looking for!!!
Thank You!

Johnny

 

[John Wilson]

Johnny,

Happy to have been a help.

John

Exactly what I was looking for!!!
Thank You!

Johnny