Hello,

I cannot attach a workbook to this since it contains Confidential information, but I was hoping someone could help me.

I work in a 911 Call Center, and we have a phone system with internal and external numbers entered into a database. That database was exported as an Excel form. The phone is setup to require pauses or extra numbers to be dialed in some cases, so the actual format of the phone numbers exported in an unusual manner, such as:

"1: h,954-963-3225; Voice: DTMF Transfer;"

There is no constant for how they appear. Typically, it will appear they way it is written above, yet other times it will be "1: 954-963-3225; Voice: DTMF Transfer;" (for example)

I only want the actual phone number to appear in the column on the revised worksheet I am creating. I know that there is a way to extract certain parts of a string of text (which I do not know how to do BTW), but can this be done if there is no uniform manner in which the text was entered? I could do it row by row and manually remove, but I am looking at roughly 6700 rows of content.

Thanks