Sp3cial_k_1975
New Member
- Joined
- Dec 27, 2013
- Messages
- 26
I have a group of numbers ex: 1, 5, 12, 16, 32, 35, 36 etc...
What I am wanting to do is take 1 and 5, 1 and 12, 1 and 16, 1 and 32, 1 and 35, 1 and 36, 5 and 12, 5 and 16, 5 and 32, etc. and combine them into the same cell.
Ex: 1, 5 = 1-5, 1, 12 = 1-12, 1, 16 = 1-16 etc.
Is there a formula to do this?
What I am wanting to do is take 1 and 5, 1 and 12, 1 and 16, 1 and 32, 1 and 35, 1 and 36, 5 and 12, 5 and 16, 5 and 32, etc. and combine them into the same cell.
Ex: 1, 5 = 1-5, 1, 12 = 1-12, 1, 16 = 1-16 etc.
Is there a formula to do this?