"Hi JOHN," and "Acme Inc" next to "ACME, Inc." are the two fastest ways to look sloppy in outreach and split one account into three in your CRM. These six formulas clean name and company columns in Google Sheets before you import. Assume full name is in A and company is in C.

1. Fix capitalization

PROPER handles ALL CAPS and all-lowercase names in one pass.

=PROPER(TRIM(A2))

Enter fullscreen mode

Exit fullscreen mode

Spot-check names like McDonald, O'Neil, and van der Berg afterwards; no formula gets every one right.

2. Split full name into first and last

First: =IFERROR(LEFT(B2,FIND(" ",B2)-1),B2) Last: =IFERROR(REGEXEXTRACT(B2,"\s(\S+)$"),"")

Enter fullscreen mode

Exit fullscreen mode

Middle names drop out of both columns, which is usually what a CRM import wants.

3.…