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@[url removed, login to view] 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