jeffcoleky
Active Member
- Joined
- May 24, 2011
- Messages
- 274
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style><style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style><style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>[TABLE="width: 0"]
<tbody>[TR]
[TD="align: right"]1[/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]D[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD]ALL DATA[/TD]
[TD]Extracted Phone Number[/TD]
[TD]Extracted Phone Type[/TD]
[TD]Extracted Percentage[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD](555) 729-4146 (PT) (ActiveLandLine) (100%)[/TD]
[TD](555) 729-4146[/TD]
[TD]ActiveLandLine[/TD]
[TD]100%[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD](555) 729-4146 (CT) (Cell) (50%)[/TD]
[TD](555) 729-4146[/TD]
[TD]Cell[/TD]
[TD]50%[/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD](555 298-0598 (ET) (LandLine) (9%)[/TD]
[TD](555 298-0598[/TD]
[TD]Landline[/TD]
[TD]9%[/TD]
[/TR]
</tbody>[/TABLE]
Link to example spreadsheet containing data on onedrive
I'm trying to extract the data into columns B, C, D from column A. Every instance in BCD is surrounded by parentheses. Any ideas on the best way to do this? The above is an example of what the data should look like if it worked properly.
<tbody>[TR]
[TD="align: right"]1[/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]D[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD]ALL DATA[/TD]
[TD]Extracted Phone Number[/TD]
[TD]Extracted Phone Type[/TD]
[TD]Extracted Percentage[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD](555) 729-4146 (PT) (ActiveLandLine) (100%)[/TD]
[TD](555) 729-4146[/TD]
[TD]ActiveLandLine[/TD]
[TD]100%[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD](555) 729-4146 (CT) (Cell) (50%)[/TD]
[TD](555) 729-4146[/TD]
[TD]Cell[/TD]
[TD]50%[/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD](555 298-0598 (ET) (LandLine) (9%)[/TD]
[TD](555 298-0598[/TD]
[TD]Landline[/TD]
[TD]9%[/TD]
[/TR]
</tbody>[/TABLE]
Link to example spreadsheet containing data on onedrive
I'm trying to extract the data into columns B, C, D from column A. Every instance in BCD is surrounded by parentheses. Any ideas on the best way to do this? The above is an example of what the data should look like if it worked properly.