Tag: Excel

How to separate first and last name in Excel

Posted on January 19, 2024

In Google Sheets, you can separate text using the ‘SPLIT’ or ‘TEXT TO COLUMNS’ functions. For ‘SPLIT,’ type =SPLIT(A1, “,”) to split text in cell A1 at each comma. For ‘Text to…