Dave O Wrote:
You might try this solution- but make a *backup* of your data so you
don't lose anything. Hightlight the column in question; click Edit
Replace. In the "find what" box enter the left parentheses ( and
leave the "replace with" box blank, and press Replace All. Then click
Edit Replace; find the right paren ) and replace with the dash mark -
. This should standardize all your entries, barring any input entries
that may have occurred.

Clever solution; except it didn't work because when Excel tries to find
the first parenthesis it can't, it says none found. So I'm kind of back
to square 1

I'd be glad to send someone the file if they're real curious about it


--
philtyler
------------------------------------------------------------------------
philtyler's Profile: http://www.excelforum.com/member.php...o&userid=12476
View this thread: http://www.excelforum.com/showthread...hreadid=539869