Excel formula for seperation of text from numbers

This query is : Resolved

dheeraj kumar (Querist)
Follow

28 October 2013
Sir

Please tell formula for separating text from
numbers

e.g. in excel cell A1

DHEERAJ KUMAR 9876913949 IS MENTIONED

I WANT TO EXTRACT ONLY CHARACTER I.E. DHEERAJ KUMAR

PL TELL THE FORMULA FOR THAT

@VaibhavJ

@VaibhavJ (Expert)
Follow

28 October 2013 Hey,

Try this sheet: http://img.chandoo.org/f/extracting%20numbers.xlsx

If you have query do revert.

Thanks//VaibavJ

@VaibhavJ

@VaibhavJ (Expert)
Follow

28 October 2013 If structure of text is same as you mentioned, you can extract by using this formula =right(A1,10)

Where cell A1 refer to cell in which you have data.

Thanks//ViabhavJ

Upgrade to CAclubindia Pro. Subscribe Now!

dheeraj kumar

dheeraj kumar (Querist)
Follow

28 October 2013 i have 10000 lines if i start counting character in each line then it will be too late

pl suggest some other alternative

@VaibhavJ

@VaibhavJ (Expert)
Follow

28 October 2013 Hi

You can do using macro!

pl send me email. I will share you excel file.

Thanks//VaibhavJ

@VaibhavJ

@VaibhavJ (Expert)
Follow

28 October 2013 Pl refer: https://www.caclubindia.com/forum/separate-text-numbers-269237.asp

Thanks//VaibhavJ