| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
What is this Strange Characet? Find/Replace
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find and Replace - Replace with Blank Space | Excel Discussion (Misc queries) | |||
| where to put results of find operation in find and replace functio | Excel Worksheet Functions | |||
| find and replace macro strange behaviour | Excel Discussion (Misc queries) | |||
| find and replace - replace data in rows to separated by commas | Excel Worksheet Functions | |||
| Strange results using .FIND in Excel VBA | Excel Programming | |||
![D[_6_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
