XLS Macro

I have an xls sheet and need to extract some data from diffrent fields cells A-G and the "C:999-999-9999" out of cell H and then cell I- the rest of the sheet.. I need the contents of cell H extracted into a single cell currently the contact info looks like this <col width="168" style="width: 126pt;" /> | JOHN SMITH H:555-513-8352 C:555-513-8352 Email:JSMITH@[login to view URL] Auth: Yes | I need the C: number extracted or the rest of the data in the cell deleted.. either way I need that C:number isolated so I can upload it someplace else hope that make sense.. I have attached a sample XLS sheet