LinkBack URL
About LinkBacks
I have a number of cells that have a question mark inside a little white block. I want to get rid of them all at once but I don't know how to search for them with Ctrl+H or Ctrl+F. Is there a way to wipe them all out at once?
I have a number of cells that have a question mark inside a little white block. I want to get rid of them all at once but I don't know how to search for them with Ctrl+H or Ctrl+F. Is there a way to wipe them all out at once?
Last edited by MSP; 08-10-2010 at 05:33 PM.
They could be carriage returns or something else. Post a workbook.
Entia non sunt multiplicanda sine necessitate
Workbook attached
They're tab characters. In B1 and copy down, =CLEAN(A1)
That did the trick. Thank you so much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks