Another way:
In an adjacent column:
=TEXT(A1,"0-?/?")
Copy down as far as necessary. Copy the column. Edit/Paste
Special/Values. Copy over, or delete, the original column.
In article ,
"biggyb75" wrote:
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.
|