Forum Discussion

const69mentions's avatar
const69mentions
Copper Contributor
Jan 26, 2021

Inserting a space into my formula

I am trying to do two tasks. I know they are simple but I am rusty...   I am creating a simple formula -A&B (A is First Name, B is Last Name) but I want a space in between the two. Also, within th...
excel
Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Jan 26, 2021

const69mentions Regarding your first question, the formula could look like this:

=A1&" "&B1

 On your second question, look into the use of VLOOKUP, INDEX/MATCH or XLOOKUP functions.

Resources