D Dhamo New Member Feb 12, 2013 #1 Hi, I am surprised when I tried to replace few bulletin points (asterisks), all the characters in the particular worksheet have been changed. Just curious to know why it is considering all characters as * and Is there any way to replace only the * alone?
Hi, I am surprised when I tried to replace few bulletin points (asterisks), all the characters in the particular worksheet have been changed. Just curious to know why it is considering all characters as * and Is there any way to replace only the * alone?
N NARAYANK991 Excel Ninja Feb 12, 2013 #2 Hi Dhamo , The asterisk is used as a wildcard character to mean everything ! When you want the asterisk to be interpreted as a special character , and not in its wildcard sense , use the combination ~* ( tilde star ) instead. Narayan
Hi Dhamo , The asterisk is used as a wildcard character to mean everything ! When you want the asterisk to be interpreted as a special character , and not in its wildcard sense , use the combination ~* ( tilde star ) instead. Narayan
