Right now I have the company name and full URL in one cell. It looks like this:

A1

COMPANY NAME http://www.companyname.com

A2
COMPANY NAME 2 http://www.companyname2.com

A3
COMPANY NAME 3 http://www.companyname3.com


I need to separate the Company name and URL. How do I do that? I want it to look like:

A1 __________________ B1
COMPANY NAME http://www.companyname.com

A2 _________________ B2
COMPANY NAME 2 http://www.companyname2.com

A3 ________________ B3
COMPANY NAME 3 http://www.companyname3.com


Thanks!