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))

--
Regards,
Tom Ogilvy



Kaj Pedersen wrote in message
...
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