Selection of Characters

  • Thread starter Thread starter ianripping
  • Start date Start date
I

ianripping

In Row A I have this information

1234 5486 5414 4781
0245 2354 5489 5642
1230 4567 4987 1253

I want to copy this information into column B but only the last 1
digits of each cell in column A.

So it would look like this in column B

5486 5414 4781
2354 5489 5642
4567 4987 1253

Any ideas
 
Hi
=RIGHT(A1,12)

though if i look at your example it seems that there are spaces between
your digits. so maybe you have to change the formula to
=RIGHT(A1,14)

Frank
 
ianripping,

Try this in Column B

=RIGHT(A1,14)

The 14 includes the two spaces in your number string.

John
 
Hey

If you don't know where the first space is, then you can use this one:

=RIGHT(A1;LEN(A8)-FIND(" ";A1;1))

Cheers,
Flemming
 
Back
Top