0

I have a excel formula for converting a column of numbers to a ; seperated list. (See solution 1 in the link).

I want to make this formula quickly and easily to apply to different columns in a variety of spreadsheets (so the column will be different). I also need to distribute the result to several users.

Is there a way to add it to a button, or perhaps the context menu on the column headers so it can easily be applied to different columns quickly

Thanks.

Al Grant
  • 101
  • 1
  • Welcome to Super User! What have you tried so far? What research have you done? :) – bertieb May 21 '18 at 00:09
  • This kind of thing is typically done using appropriate absolute and relative addressing, and then simple copy and paste. Can you clarify why that wouldn't work for your requirement? – fixer1234 May 21 '18 at 00:46

0 Answers0