Forum Discussion

BobSharma's avatar
BobSharma
Copper Contributor
May 27, 2024

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?

 

 

  • Harun24HR's avatar
    Harun24HR
    Bronze Contributor
    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.

Resources