Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hep with Find and Replace
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find & Replace: find part cell, replace whole cell | Excel Worksheet Functions | |||
Find and Replace - Replace with Blank Space | Excel Discussion (Misc queries) | |||
where to put results of find operation in find and replace functio | Excel Worksheet Functions | |||
find and replace - replace data in rows to separated by commas | Excel Worksheet Functions | |||
find replace cursor default to find box | Excel Discussion (Misc queries) |