| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Can I find and replace "white space" in a cell in Excel?
I am using Excel 2002. I have a spreadsheet set up as a retrival matricie
that I will upload into an AS400. In one of the columns there are dimensions that are set up as whole number space fraction; ie 3 1/2. I need to replace the space with a "-" so that the cell would read 3-1/2. Is there a way to do that using "Find and Replace". One of the spreadsheets has over 7000 rows, I don't want to have to do this by hand. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HOW DO I TOGGLE FROM FIND AND REPLACE TO A CELL EASILY? | Excel Discussion (Misc queries) | |||
| find and replace cell reference to a new worksheet | Excel Worksheet Functions | |||
| How can I do a find and replace for a cell that has multiple line. | Excel Discussion (Misc queries) | |||
| How Can I find and replace symbols in excel data ( white square) | Excel Discussion (Misc queries) | |||
| VB Find and Replace | Excel Worksheet Functions | |||
Threaded Mode
