You're welcome.

Pete

On Dec 8, 1:46 pm, Narasimha
wrote:
thanks Pete



"Pete_UK" wrote:
Is your numeric always three digits?

If so, you can get the numeric part (as a number) with:

=RIGHT(A1,3)*1

(miss off the *1 if you want it as text), and the alpha part with:

=LEFT(A1,LEN(A1)-3)

Hope this helps.

Pete

On Dec 8, 12:32 pm, Narasimha
wrote:
Hi all,
how do separate alpha numeric value for example I have values like
ABC123,AB234
starts with alpha but the length may be 2 or 3 or 4. just I want alpha value
in one column and numeric in another column.

could anyone help me ?
thanks- Hide quoted text -

- Show quoted text -