Find and copy part of a cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hallo,

I want to copy the last 10 spaces, always numbers/always 10, in cell A1 into
cell B1. Can anyone help with a function that does this job?
This is how cell A1 looks like:
ABCDE AB 123 4 5 67
ABC A 123 4 5 67

Thanks,

Srwe
 
Do you want the spaces as well as the numbers? Then use

=RIGHT(A1,10)

If you want the last 10 non-space characters, use

=RIGHT(SUBSTITUTE(A1," ",""),10)
 
Thanks!
Srwe

Duke Carey said:
Do you want the spaces as well as the numbers? Then use

=RIGHT(A1,10)

If you want the last 10 non-space characters, use

=RIGHT(SUBSTITUTE(A1," ",""),10)
Click to expand...
 
Back
Top