Hi, if it's variable format without any seperating character like . or - then
it'll be extremely difficult without resorting to VBA.

A fixed format of 3 letters and then variable numbers it's is easier.
= right(A1,len(A1)-3)
3 letters and then 3 numbers even simpler:
=right(A1,3).

Post up if this helps or if you need a macro.

HTH

Giz

"ThomasVike" wrote:

In a cell there is text and numbers, example: ABC123. In an other cell I want
to show the numbers only (123).

I can't find a useful function, any suggestions?