Merge Multiple cells into One

chrisl614

Member
Joined
Apr 6, 2019
Messages
30
Reaction score
0
Points
6
Excel Version(s)
2016
I have a multiple spread sheets that have columns named select your name with a number infront of it.
There is only 1 name per in these columns per row. I need to get all those names into the first column. I'm looking for a way to do this without using =A2&b3&c2 (etc...) reason I don't want to use that formula is because each sheet has this information in different columns and I don't want to have to retype this formula all the time.

If there's a simple way to do this please let me know. attached is an example.
 

Attachments

  • Example.xlsx
    14.9 KB · Views: 9
How about using the CONCAT function to grab everything in the rest of the row?
 
Just tried that and it worked perfectly! Thank you!


Sent from my iPhone using Tapatalk
 
Back
Top