| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to find and replace blank space (x) in John Smithx in Exce
Works fine! Thanks a lot!
"Fred Smith" wrote: The Trim function will get rid of trailing spaces without affecting internal spaces. -- Regards, Fred "JoeSAT" wrote in message ... kecause of data entry irregularities, my records look like this: John Smith 10 John Smithx 12 John Smith 8 When I use PivotTable to sum sales, I get two sums for John Smith. How can I find and replace the blank space x without removing the space between John and Smith? Thank you. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find and replace should work in Excel text boxes | Excel Discussion (Misc queries) | |||
| Excel 2003 Find and Replace is changed to previovois ver.-awful!! | Excel Discussion (Misc queries) | |||
| find and replace path name in Excel cells containing hyperlink | Excel Discussion (Misc queries) | |||
| Can I find and replace "white space" in a cell in Excel? | Excel Worksheet Functions | |||
| macro to Find Replace in Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
