| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
find replace excel remove single character
Yes, thank you - that worked. Thanks for your help.
"MartinW" wrote: Hi Alaska Boy, ? is a wildcard character try it this way ~? in your find/replace HTH Martin "AlaskaBoy" wrote in message ... Excel 2007. Big spreadsheet. 15000 rows. One column has for some reason randomly added a question mark at the end of a bunch one word text in this column (they're brand names). I want to replace the ? with a blank space. When I do it, though, I end up with a blank cell. There must be a way to just take out all the question marks in column B. What am I missing? Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find replace the 1st character in a cell | Excel Discussion (Misc queries) | |||
| find a replace character question | Excel Discussion (Misc queries) | |||
| find a character and replace with a command in Excel | Excel Discussion (Misc queries) | |||
| How do you find and replace a Wildcard character in Excel? | Excel Discussion (Misc queries) | |||
| How to remove or replace a carriage return character in a cell? | Excel Discussion (Misc queries) | |||
Threaded Mode
