Parse Phone Numbers (Main, Office, Cell)

[suriyahi]

Hey Guys,
Need your expretise here.

I get this .csv and it has phone numbers in a single column. I need help with extracting them and placing them into 3 separate columns. For example:

main: 317-577-1234 x370 / office: na / cell: namain: 248-601-2531 / office: na / cell: 248-601-2531main: 819 862-2216 / office: na / cell: namain: 518-594-7644 / office: na / cell: namain: 518-594-7644 / office: na / cell: namain: na / office: 518-594-7644 / cell: namain: 518-594-7644 / office: na / cell: namain: 518-594-7644 / office: na / cell: namain: 201-473-3812 / office: na / cell: 201-473-3812main: 201-473-3812 / office: 201-473-3812 / cell: 201-473-3812main: 419 7411100 / office: na / cell: namain: (234) 253-3374 / office: na / cell: namain: (234) 253-3374 ext. 376 / office: na / cell: namain: 710-919-7443 Mike Lai's Cell / office: na / cell: (234) 253-3374main: 503-524-9200 / office: na / cell: namain: (540) 850-4311 / office: na / cell: na

So, as you can see, there is a pattern of '/' after each phone number fields. I appreciate your help with this. Thanks!

[suriyahi]

Attached is the sample: Thanks!!

[Bob Phillips]

Simply do a Data>Text To Columns with a delimiter of /

[suriyahi]

That worked. Solved!!