How to Combine two cells
I am trying to combine the Last Name and First Name column.
Please see the formula that I used below:
=[Last Name]@row + "," [First Name]@row
Answers
-
Try adding another plus between the comma and the second column reference.
=[Last Name]@row + "," + [First Name]@row
-
Perfect this worked.
Now I am struggling to pull in the emails from another sheet.
I used the formula below:
=IFERROR(INDEX({Copy of Master DPS Directory Range 1}, MATCH([Full Name]@row, {Copy of Master DPS Directory Range 2}, 0)), "")
-
Formula looks good @Louis.Smith
What is it doing or not doing? Is there an error, or it is just not matching?
Make sure the range you have called Copy of Master DPS Directory Range 1 contains the email addresses and Copy of Master DPS Directory Range 2 contains the names in exactly the same format (i.e. surname comma firstname).
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!