Remove numbers from cells with text

[teicfcl]

Hi,

I have copied information from an outside source to Excel. Unfortunately, the information includes numbers preceding the text which I need to delete for all records. Is there an easier way of deleting this information without going to each individual cell to delete the numbers?

Your assistance with this issue is greatly appreciated.

Thank you,
teicfcl

 

[teicfcl]

<tt><tt>mikerickson,

Thank you. Will try.

Have a great Sunday!

-teicfcl
</tt></tt></pre>

 

[fabema]

Hello,


I have column A with 3021 rows, where there are numbers and text like this: 26,33,Cosmetice/Ingrijire Piele,62


I need to delete the numbers and the comma, and keep the text.


Is that possible?


Thank you

 

[SimosStavrakidis]

Hello,


I have column A with 3021 rows, where there are numbers and text like this: 26,33,Cosmetice/Ingrijire Piele,62


I need to delete the numbers and the comma, and keep the text.


Is that possible?


Thank you

All you have to do is 10 simple replacement actions giving each time a different number from 0-9 ... to be replaced by ...nothing. Just remember that there are brands that have numbers like B52 for example. Then you can replace , with nothing also , or / with nothing and you have youe job done.

 

[frankis72]

All you have to do is 10 simple replacement actions giving each time a different number from 0-9 ... to be replaced by ...nothing. Just remember that there are brands that have numbers like B52 for example. Then you can replace , with nothing also , or / with nothing and you have youe job done.

This is an old thread...and I'm a new member, but I just had to make an account thanking SimosStavrakidis. Such an easy solution!! It took a maximum of 30 seconds to accomplish this.

 

[qmarswo]

I know its old, but it might help someone in the future:

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"1",""),"2",""),"3",""),"4",""),"5",""),"6",""),"7",""),"8",""),"9",""),"0","")

Just replace A1 with the cell you want to clear numbers from. You can also add further nested SUBSTITUTE terms to remove other unwanted characters.

 

[ankur_fox]

All you have to do is 10 simple replacement actions giving each time a different number from 0-9 ... to be replaced by ...nothing. Just remember that there are brands that have numbers like B52 for example. Then you can replace , with nothing also , or / with nothing and you have youe job done.

3 years since your post and I too signed up only to say thanks! Best 30 seconds of my life

 

[StylinGirl]

3 years since your post and I too signed up only to say thanks! Best 30 seconds of my life

- New member here too- had to join just to say thanks for that delightfully simple solution!!