Forum Discussion
Separating columns in Excel based on their values
I have a long excel list where column E is used for the "attribute Name" and Column F for the "Attribute Value". I need to break each attribute name into different columns and populate their respecti...
LuisSiqueira
Try something like this:
=LEFT(E2, SEARCH(" ",E2,1)-1)
=MID(E2, SEARCH(" ",E2) + 1, SEARCH(" ",E2,SEARCH(" ",E2)+1) - SEARCH(" ",E2) - 1)
=RIGHT(E2,LEN(E2) - SEARCH(" ", E2, SEARCH(" ", E2) + 1))
Put them in whatever 3 columns you have free (EG. Columns J,H,K) in that order