Question Locked
How can I automatically create a string of reference designators
0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have BOM information which looks like this in a single Excel cell: R1-R5.
Does anyone have a formula or command for automatically changing that cell to: R1,R2,R3,R4,R5
Thanks for your help