Split The First And Last Name With A Formula
4 minute read These formulas cover the most typical scenario when you have the first name and last name in one column separated by a single space character. Formula to get first name The first name can be easily extracted with this generic formula: ‘ first name LEFT(cell, SEARCH(” “, cell) – 1) You use … Read more