MrExcel Publishing
Your One Stop for Excel Tips & Solutions

removing asterick

Posted by Justin on January 15, 2002 2:08 PM

I have numberous rows of different numbers that are six digits followed by an asterick. I want to remove all astericks from the end of the six digit numbers.

Example 444555* to 444555
565123* to 565123

When we use the find and replace it deletes the entire cell.


Posted by bob Umlas on January 15, 2002 2:11 PM

Find ~* and replace with nothing. Asterisk is a wildcard. the tilde (~) indicates an override -- makes the asterisk an asterisk.

Posted by Aladin Akyurek on January 15, 2002 2:21 PM

Select the column range of interest.
Activate Data|Text to Columns.
Specify as delimiter *.



Posted by Justin on January 16, 2002 7:00 AM

Thanks alot for your tip! You have saved me and my buddy alot of hand-time! thanks again.