Copy only the digits from a cell

[Kaj Pedersen]

Hi group,
In a cell I have written first a text, then a space, and finally some digits
(between 3 and 5)

Is it possible, with the help of a formula or a macro, to copy only the
digits to a new cell?



Regards,

Kaj Pedersen

 

[Tom Ogilvy]

does "a text" mean a single character, so that the numbers always start as
the third letter in the string
=Right(A1,len(a1)-2)

If not, you will need to use the find command to fine the space.

=RIGHT(A1,LEN(A1)-FIND(" ",A1))

 

[Kaj Pedersen]

Hi Tom,
The FIND command was exactly what I needed.
Thanks for your help.

Regards
Kaj Pedersen