|re: "I need to remove the brakets athe dash."|
Is this supposed to say:
"I need to remove the brackets and the dash."?
If so, what do you want the output to look like?
2095551234 or 209 555 1234 or 209 5551234 or ???
A Posting Tip:
Since we can't see your workbook from where we're sitting (or read minds) it helps us help you if you tell us exactly what you are starting with and exactly what you want the output to look like.
Otherwise, we could toss out possible solutions all day, none of which will fit your needs.
Office Forum Moderator