Hello,
I have a sheet of data and I would like to remove all value starting by a digit in each cell:
Example:
A1= Minute Maid Orange Juice 11 fl oz bottle.
A2= Diet coke 10 oz bottle
Need result as follow:
A1= Minute Maid Orange Juice B1= 11 fl oz bottle
A2= Diet Coke B2= 10 oz bottle
What is the best way to do this?
Thank you!
I have a sheet of data and I would like to remove all value starting by a digit in each cell:
Example:
A1= Minute Maid Orange Juice 11 fl oz bottle.
A2= Diet coke 10 oz bottle
Need result as follow:
A1= Minute Maid Orange Juice B1= 11 fl oz bottle
A2= Diet Coke B2= 10 oz bottle
What is the best way to do this?
Thank you!