You might find this useful... here is Microsoft's listing for the location
of what seems like every Xl2003 to XL2007 command...

http://74.125.47.132/search?q=cache:...&ct=clnk&gl=us

--
Rick (MVP - Excel)


"George" wrote in message
...
Jacob - I am using Excel 2007 and can not find Edit - Replace !

Thanks

"Jacob Skaria" wrote:

Select the column.From menu EditReplaceFindwhat put the dash.
Replace with 'leave blank. and OK
--
If this post helps click Yes
---------------
Jacob Skaria


"George" wrote:

Each month I receive an excel spreadsheet and one of the columns has
social
security numbers with the dashes. I have to import it into Access
without the
dashes, how can I remove the dashes from the social security numbers in
Excel
- without doing it by hand ? Is there a way to use format cells to
clear the
dashes ?

Thanks