How to Concatenate First Letter of First Name and Full Last Name in Excel : Mater Dei High School - Information Technology Help Desk

How to Concatenate First Letter of First Name and Full Last Name in Excel Print

Modified on: Tue, 17 Nov, 2020 at 1:55 PM

Concatenate First Letter of First Name and Full Last Name in Excel

Select destination cell, type “CONCATENATE(LEFT(< cell with first name >,1),< cell with last name >)” and press “Enter” key on Windows or “return” key on Mac.
The destination cell with concatenate the first letter of the first name with the whole last name together.

Did you find it helpful? Yes No

Help Desk Software by Freshdesk