I have data of different companies like names, addresses, phone numbers and emails in one column of an Excel workbook. How do I separate these columns using Excel formulas?
Here is the sample data:
<code style="margin: 0px; padding: 0px; border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; white-space: inherit;">America
Dan Wilson
Ogilvy PR Worldwide
Bingham Farms, MI: 32270 Telegraph Road,
Suite 200, Bingham Farms, MI 48025
OPRGenpact@ogilvy.com
+1 212-880-5346
India
Rudra Bose
Genesis Burson-Marsteller
Unitech Infospace, Central Park II,
Sector 48, Gurgaon, Haryana
+91 124 441 7592
Europe
Quintin Keanie
Ogilvy Public Relations
Berkshire: Vandervell House,
Vanwall Business Park, Maidenhead,
Berkshire SL6 4UB, England, United Kingdom
genpactuk@uk.ogilvypr.com
+44 207 227 5200</code>
Here is the sample data:
<code style="margin: 0px; padding: 0px; border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; white-space: inherit;">America
Dan Wilson
Ogilvy PR Worldwide
Bingham Farms, MI: 32270 Telegraph Road,
Suite 200, Bingham Farms, MI 48025
OPRGenpact@ogilvy.com
+1 212-880-5346
India
Rudra Bose
Genesis Burson-Marsteller
Unitech Infospace, Central Park II,
Sector 48, Gurgaon, Haryana
+91 124 441 7592
Europe
Quintin Keanie
Ogilvy Public Relations
Berkshire: Vandervell House,
Vanwall Business Park, Maidenhead,
Berkshire SL6 4UB, England, United Kingdom
genpactuk@uk.ogilvypr.com
+44 207 227 5200</code>