Inserting a space into my formula

%3CLINGO-SUB%20id%3D%22lingo-sub-2096738%22%20slang%3D%22en-US%22%3EInserting%20a%20space%20into%20my%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2096738%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20do%20two%20tasks.%20I%20know%20they%20are%20simple%20but%20I%20am%20rusty...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20creating%20a%20simple%20formula%20-A%26amp%3BB%20(A%20is%20First%20Name%2C%20B%20is%20Last%20Name)%20but%20I%20want%20a%20space%20in%20between%20the%20two.%3C%2FP%3E%3CP%3EAlso%2C%20within%20the%20same%20worksheet%20but%20on%20different%20tabs%2C%20I%20want%20to%20match%20name%20to%20name%20in%20order%20to%20match%20up%20work%20location.%26nbsp%3B%20I%20created%20a%20new%20tab%20and%20inserted%20all%20the%20columns%20I%20need%2C%20but%20not%20sure%20how%20to%20compare%20the%20data.%20How%20do%20I%20do%20this%3F%3C%2FP%3E%3CP%3Eexample%3C%2FP%3E%3CP%3EColumn%20A%20is%20Name%20B%20is%20Work%20Place%2C%20C%20is%20Title%20then%20D%20is%20list%20of%20names%20to%20match%20from%20separate%20worksheet%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2096738%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2096753%22%20slang%3D%22en-US%22%3ERe%3A%20Inserting%20a%20space%20into%20my%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2096753%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F942618%22%20target%3D%22_blank%22%3E%40const69mentions%3C%2FA%3E%26nbsp%3BRegarding%20your%20first%20question%2C%20the%20formula%20could%20look%20like%20this%3A%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DA1%26amp%3B%22%20%22%26amp%3BB1%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3BOn%20your%20second%20question%2C%20look%20into%20the%20use%20of%20VLOOKUP%2C%20INDEX%2FMATCH%20or%20XLOOKUP%20functions.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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

@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.