Hi,
I have some customer number data, whereas each customer number is in it's own cell. I want to combine all the customer numbers into one cell, with each number seperated by a comma.
I know I can use the =A1&","&A2 thing, but there's 25+ numbers to combine.
All numbers are 6 digits long.
Is there an easier way to do this, say with the Concantenate Function?
Sample spreadsheet attached.
Thanks
Rick
Bookmarks