How do I combine the first character of a cell with another cell in Excel

Question

I have an Excel sheet with first names in Column A and surnames in Column B  I want to create a third Column C that contains the first character from the first name and adds it to the surname  creating first initial   surname   First Name    Last Name    Combined Name John          Smith        jsmith   How can I do this using Excel

User · Answer

Not sure why no one is using semicolons  This is how it works for me    CONCATENATE LEFT A1 1   B1    Solutions with comma produce an error in Excel

User · Answer

This is what formula I used in order to get the first letter of the first name and first letter of the last name from 2 different cells into one    CONCATENATE LEFT F10 1  LEFT G10 1   Lee Ackerman   LA

User · Answer

Use following formula    CONCATENATE LOWER MID A1 1 1   LOWER  B1     for  Josh Smith   jsmith   note that A1 contains name and B1 contains surname

User · Answer

CONCATENATE LEFT A1 1   B1    Assuming A1 holds 1st names  B1 Last names

User · Answer

QUESTION was  suppose T john is to be converted john T  how to change in excel   If text  T john  is in cell A1   CONCATENATE RIGHT A1 LEN A1 -2      LEFT A1 1     and with a nod to the  amp  crowd   RIGHT A1 LEN A1 -2  amp     amp LEFT A1 1    takes the right part of the string excluding the first 2 characters  adds a space  adds the first character

User · Answer

Personally I like the  amp  function for this  Assuming that you are using cells A1 and A2 for John Smith   left a1 1   amp  b1   If you want to add text between  for example a period   left a1 1   amp       amp  b1

[excel] How do I combine the first character of a cell with another cell in Excel?

Examples related to excel

Examples related to excel-formula