Changing format of imported data

[Frank Kabel]

Hi
try
'Edit - Replace'

-----Original Message-----
I frequently import payroll data from QuickBooks to

Excel. One column of that data is employees' social
security numbers. For the report I do, I must remove the
hyphens from the social security numbers (from xxx-xx-xxxx
to xxxxxxxxx). Is there a shortcut to do this?