Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find And Replace a Dash
How do I do this? Look at Phone Number...I need the dash.
Actual 4915 N Federal Highway<brLighthouse Point,, FL 33064<brPhone: 9544809085 11 West 2ND Avenue<br<brWilliamson,, WV 25661<brPhone: 3042355659 10673 W Street<br Charles Road<brSumner, MI 48889<brPhone: 9898332265 This is what I would like to finish with. I have hundreds of these. Results 4915 N Federal Highway<brLighthouse Point,, FL 33064<brPhone: 954-480-9085 11 West 2ND Avenue<br<brWilliamson,, WV 25661<brPhone: 304-235-5659 10673 W Street<br Charles Road<brSumner, MI 48889<brPhone: 989-833-2265 Thank You Steve |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Replace Comma's with Dash | Excel Worksheet Functions | |||
Replace Comma with Dash | Excel Worksheet Functions | |||
replace dash in a number sequence | Excel Worksheet Functions | |||
Replace Error with a Dash | Excel Worksheet Functions | |||
Find an empty cell and put a dash in it? | Excel Worksheet Functions |