Separate \"data\" in column B into three columns using formulas that can be copi

Question

Separate "data" in column B into three columns using formulas that can be copied down The formulas need to be created in row 6 (cells C6, D6, E6) and copied down to other rows Imagine there is 1000 records, not just 8 data ID NAME Price 402 aspirin 4.05 <--formulas here can be copied down for potentially 1000 records 512 neosporin 3.54 4823 toothpaste 2.35 6685 devil's brew 4.83 479 tylenol 5.65 5678 hand soap 3.20 436 advil 3.27 6738 shower gel 3.89 Separate "data" in column B into three columns using formulas that can be copied down The formulas need to be created in row 6 (cells C6, D6, E6) and copied down to other rows Imagine there is 1000 records, not just 8

Explanation / Answer

The data can be seperated using Data to columns function in excel. We can use the space as a delimited identifier to seperae the data.

It can also be done using Left and FIND funtion in excel directly.

==LEFT(A1,(FIND(" ",A1,1)-1))

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.