I am copying a large sheet into a spread sheet. The problem is one of the columns contain numbers with some cells having an asterisk at the end of the number. This causes problems with the formulas on other sheets that use this data. Can I use a formula or what is the best way to eliminate the "*".
Last edited by elcasey125; 12-05-2008 at 10:09 PM.
Find (~*) and Replace (leave blank).
Hi and welcome to the board
Try Ctrl +H
Find what : ~*
Replace with ( nothing)
Replace All
It's very important to use the ~ before the asterisk otherwise it won't work ( * is for wildcards)
Thanks worked perfect! What a differance the "~" makes.
You are welcome. Can you now kindly mark your thread as Solved?
Edit your original post
Click Go Advanced
Select [Solved] from the drop down where it says [No Prefix]
Click Submit.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks