Formula needed to seperate numbers and letters

[sherbetdab]

Hi all, just new to the site and only recently started working with excel due to change of employment.
I have a sheet where in one column i have letters and numbers eg RT76454 name address 2333
What i need is a formula which would read the RT76454 and put just the 76454 into another cell.

Thanks in advance.

[dilipandey]

Hi Sherbetdab,

Welcome to the forum.

Would suggest you to go through the forum rules :-
http://www.excelforum.com/forum-rule...rum-rules.html

and also change title of this thread to reflect the query being asked.. thanks.


Regards,
DILIPandey

<click on below 'star' if this helps>

[RobertMika]

Is the pattern goin to be the same.?
Two letters and then digits?
=MID(A1,3,4)

[sherbetdab]

Sorry about that. Hope the new title is ok,

[sherbetdab]

Is the pattern goin to be the same.?
Two letters and then digits?
=MID(A1,3,4)

Yeah the pattern is the same in each row of the column 2 letters followed by 5 numbers.
I need the numbers to use in a new column.

[Cutter]

You can use:
=RIGHT(A1,5) to produce a text string of the 5 digits or
=RIGHT(A1,5)*1 to produce a numeric value

in either case A1 would be the cell holding the original value

[sherbetdab]

Thanks for your help guys, cutter was on the money, Cheers.

[Cutter]

You're welcome. Thanks for the 'star tap'.