Howdy,
I am having to play around with heaps of data entries and for whatever reason some data includes an asterisk *
I have attempted to find/replace the * symbol to either change or remove it, but for some reason in Excel this method won't work with the * symbol (changes the whole text string rather then just the *)!!? So currently having to paste the data into Word to find/replace any * and then back to Excel (which is proving very time consuming with large data lists).
Is there a formula that will allow me to search a text string and replace any * with a specified criteria and why doesn't Excel like the little blighters?
Example:
Formula changes any * with a number 1
John* = John1
*House = 1House
Mr*Excel = Mr1Excel
Thx
Egg
******************************************
I am having to play around with heaps of data entries and for whatever reason some data includes an asterisk *
I have attempted to find/replace the * symbol to either change or remove it, but for some reason in Excel this method won't work with the * symbol (changes the whole text string rather then just the *)!!? So currently having to paste the data into Word to find/replace any * and then back to Excel (which is proving very time consuming with large data lists).
Is there a formula that will allow me to search a text string and replace any * with a specified criteria and why doesn't Excel like the little blighters?
Example:
Formula changes any * with a number 1
John* = John1
*House = 1House
Mr*Excel = Mr1Excel
Thx
Egg
******************************************
Last edited: