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 the same worksheet but on different tabs, I want to match name to name in order to match up work location.  I created a new tab and inserted all the columns I need, but not sure how to compare the data. How do I do this?

example

Column A is Name B is Work Place, C is Title then D is list of names to match from separate worksheet

1 Reply

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor

    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