Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
find replace excel remove single character
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
find replace excel remove single character
The question mark is a joker that replace any character (including itself).
To limit its range of action to only genuine question marks, use ~? instead of ? "AlaskaBoy" wrote: 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
find replace excel remove single character
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
find replace excel remove single character
So in the Find I tried putting ~? and it says it found nothing. What would I
put in the Find field? "FiluDlidu" wrote: The question mark is a joker that replace any character (including itself). To limit its range of action to only genuine question marks, use ~? instead of ? "AlaskaBoy" wrote: 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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
find replace excel remove single character
Forget my last question - got that to work. I had to clear the format.
Thank you, thank you, thank you. "FiluDlidu" wrote: The question mark is a joker that replace any character (including itself). To limit its range of action to only genuine question marks, use ~? instead of ? "AlaskaBoy" wrote: 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. |
#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. |
Reply |
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) |