Hi Tom,

Are all the phone numbers entered in the same format with the hyphens? If
they are then you can use Find and Replace.

NOTE: Backup you workbook before doing this in case it returns unexpected
results.

Select the column of data.
Select Replace
In the Find field enter ???-???-????
Leave the replace field blank.
Click Replace all

--
Regards,

OssieMac


"Tom" wrote:

I have a spreadsheet in excel 2003. In cell a1 I have a name for
example:Smith,Lisa
In cell B2 I have an address and a phone number
for example
1234 Anywhere st
Akron,Ohio 44332
330-555-1212

I need to eliminate the phone number from the second field in order to use
it as the basis for a mail merge
In other words I only want the street, city and state left without the phone
number

I can't figure out how to do that successfully. The street
then the city state and zip
and finally the phone are on different lines in the same field

Can you put me in the right direction? Thanks so much