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.
To separate first name and last name use TEXTSPLIT() function.