Split string into multiple columns in Excel
I am attempting to take the following string:
"companyName - accountName"
and transpose it to multiple columns so it reads like this
"companyName" "accountName"
in separate columns
Can some help educate me about the formula I would
use to do such a thing?!
Answer:
In column A2 type =LEFT(A1;FIND("-";A1)-1) and in A3 type =RIGHT(A1;LEN(A1)-FIND("-";A1))
(for formulas, depending on your country, you might have to change ; with , or the opposite