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
