Combine Specific Characters from Multiple Cells

LindsayM

Is there a formula that lets you take the first character in one cell and the full contents of another cell? Example: a signup that generates usernames based on the first/last name of the individual.

Gillian C

Hi @LindsayM

You should be able to do

= LEFT([First Name]@row,1) + [Last Name]@row

If you want spaces or other delimiters between the two combined values then you can do the following

= LEFT([First Name]@row,1) + " " +[Last Name]@row (which will give a value of J Doe)

= LEFT([First Name]@row,1) + "-" + [Last Name]@row (which will give a value of J-Doe)

Hope that gives you a starting point.

Gillian C

Hi @LindsayM

You should be able to do

= LEFT([First Name]@row,1) + [Last Name]@row

If you want spaces or other delimiters between the two combined values then you can do the following

= LEFT([First Name]@row,1) + " " +[Last Name]@row (which will give a value of J Doe)

= LEFT([First Name]@row,1) + "-" + [Last Name]@row (which will give a value of J-Doe)

Hope that gives you a starting point.

LindsayM

@Gillian C This is perfect! Exactly what I needed, thank you!