Replace it with a character that isn't used. Maybe the vertical bar (|).

Then use that in your data|text to columns.

(I'd still use that other macro <bg.)

D wrote:

ok- tried doing Alt+0011 and it said it couldnt find anything to replace. I
also tried a Clean() function, and THAT DID work- but, I dont want to delete
the character since I need to find/replace and then go text to columns with
it. Any other ideas?
Thanks guys!
D

"Chip Pearson" wrote in message
...
In the Find box, hold down the ALT key and type 0011 on the numeric keypad
(not the number keys above the letters).


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"D" wrote in message news:VCapd.75122$EZ.14343@okepread07...
BTW- I did a =CHAR(A1) on it and it comes back as 11.

So how do I do a find/replace on this thing now?
Thanks!
D

"D" wrote in message news:svapd.75121$EZ.36941@okepread07...
Hey guys-
Got a CSV file here that has an address field using a weird character to
separate the address line from the city/state/zip. The character is a
square box. I'm trying to do a find/replace on the thing, but, I don't
know what it is to be able to tell excel to find it. I've tried to
copy/paste it into the Find/Replace search box, but it won't recognize
it. Can someone tell me what this character is (is it a 'return' signal,
a tab, what?) so that I can replace it with a normal character in excel?
Thanks!
D






--

Dave Peterson