format cell

W

wab

I have this in a cell; "2 vs 3" (without quotes), I want
to find and replace it with "2 - 3" (without quotes).
When I do this it either turns it into a date or a string
of five numbers. I have formatted the cell to be "text"
or "general" yet it still converts to a date or a string
of numbers. I would appreciate any help, thank WAB
 
P

PCLIVE

WAB,

Try replacing with '2 - 3.

Using the single quote at the beginning will force to maintain the text.
Don't worry, the sinqle quote will not show in the cell.

HTH,
Paul
 
Top