| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to Replace ? With Space
Dear Experts!
I have a data like Below mentioned Hardeep?kanwar Hardeep?kanwar pai kanwar? renu kanwar pai?Kanwar Now i want to Replace ? mark with Single Space I try Ctrl+H Find What: ? Replace With: Space but Delete the All the Data Pls help me |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to Replace ? With Space
Hi,
Excel is teating ? as a wildcard so to make it a literal character used a tilde search for ~? Mike "Hardeep kanwar" wrote: Dear Experts! I have a data like Below mentioned Hardeep?kanwar Hardeep?kanwar pai kanwar? renu kanwar pai?Kanwar Now i want to Replace ? mark with Single Space I try Ctrl+H Find What: ? Replace With: Space but Delete the All the Data Pls help me |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to Replace ? With Space
Thanks for the Quick Reply
Works like a Magic Hardeep kanwar "Mike H" wrote: Hi, Excel is teating ? as a wildcard so to make it a literal character used a tilde search for ~? Mike "Hardeep kanwar" wrote: Dear Experts! I have a data like Below mentioned Hardeep?kanwar Hardeep?kanwar pai kanwar? renu kanwar pai?Kanwar Now i want to Replace ? mark with Single Space I try Ctrl+H Find What: ? Replace With: Space but Delete the All the Data Pls help me |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to Replace ? With Space
Why not try following?
If data is in A1, then in cell B1, type =substitute(a1,"?"," ") hsg "Hardeep kanwar" wrote: Dear Experts! I have a data like Below mentioned Hardeep?kanwar Hardeep?kanwar pai kanwar? renu kanwar pai?Kanwar Now i want to Replace ? mark with Single Space I try Ctrl+H Find What: ? Replace With: Space but Delete the All the Data Pls help me |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find and Replace - Replace with Blank Space | Excel Discussion (Misc queries) | |||
| replace space | Excel Worksheet Functions | |||
| Replace (') to space | Excel Worksheet Functions | |||
| Replace a ; with a , and a space | Excel Worksheet Functions | |||
| Word: replace ... ... with space | Excel Discussion (Misc queries) | |||
Linear Mode
