Forum Discussion
const69mentions
Jan 26, 2021Copper Contributor
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...
Riny_van_Eekelen
Jan 26, 2021Platinum Contributor
const69mentions Regarding your first question, the formula could look like this:
=A1&" "&B1On your second question, look into the use of VLOOKUP, INDEX/MATCH or XLOOKUP functions.