Remove asterisk with tilde

[bobhc]

Good day All


I have a data table in which some names terminate in an asterisk ,I have tried using find and replace by preceding the asterisk with a tilde ~, but I am having no luck, would appreciate a pointer of two in the right direction. Copy of file in Dropbox folder


https://dl.dropbox.com/u/75495784/LargeSalesData.xlsx

 

[oldchippy]

Hi bobhc,


What you are doing worked for me??

 

[Luke M]

Alternatively, if you really get stuck, you can use the SUBSTITUTE function. It doesn't recognize wildcards, so will literally remove the * from a word if it exists.

=SUBSTITUTE(A2,"*","")

 

[bobhc]

Good day Luke M


Perfect work as I needed, my thanks


oldchippy,please extrapolate on your post, because I have no idea as to what you are alluding to

 

[oldchippy]

Hi bobhc,


I did exactly the same as you did with the find/replace on column A on the DataTable tab.


Find ~*


Replace with nothing


123 replacements carried out

 

[bobhc]

Good day oldchippy


I have used the ~ many times before and it has all ways worked not sure why it did not this time? Still the =SUBSTITUTE worked, may be easyer to use than FIND/REPLACE