Forum Discussion
trying to edit entire column
how do I apply this formula to the entire column B3 to B1873?
=LEFT(B3, LEN(B3) - 10)
Also, I have a column with first and last name together, is there a way to separate these into 2 columns?
- If you are a user of Microsoft Excel 365 then could try =LEFT(B3:B1873, LEN(B3:B1873) - 10)
To separate first name and last name use TEXTSPLIT() function.
