How to delete the digits and the following spaces in the beginning of a string

**sumesh56** · 10-24-2014, 09:32 PM

i want to delete the digits and the following spaces at the beginning of the strings in B col. kindly see the attached. thanks

**Ron Coderre** · 10-24-2014, 09:50 PM

Using your posted workbook,
this regular formula, copied down returns the text after leading numbers

Please Login or Register  to view this content.

Is that something you can work with?

**Vikas_Gautam** · 10-24-2014, 10:15 PM

here is my way..

Formula:

Please Login or Register  to view this content.

**sumesh56** · 10-25-2014, 12:33 AM

Originally Posted by Ron Coderre

Using your posted workbook,
this regular formula, copied down returns the text after leading numbers

Please Login or Register  to view this content.

Is that something you can work with?

exactly . thanks a lot. have a nice day.

**sumesh56** · 10-25-2014, 12:34 AM

Originally Posted by Vikas_Gautam

here is my way..

Formula:

Please Login or Register  to view this content.

works fine . thanks . have a nice day.

**abousetta** · 10-25-2014, 12:35 AM

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

Re: How to delete the digits and the following spaces in the beginning of a string