Find and copy part of a cell

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)

"Srwe" wrote:

> 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

Thanks!
Srwe

"Duke Carey" wrote:

> 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)
>
> "Srwe" wrote:
>
> > 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