richardallen
New Member
- Joined
- Feb 13, 2014
- Messages
- 12
Grateful with some help on a vba task. I am looking to use convert this list:
ABC21256/03/04
ABC21311/01/09/11
ABC21313/02
ABC21378/07/08/31
into to this list:
ABC21256/03
ABC21256/04
ABC21311/01
ABC21311/09
ABC21311/11
ABC21313/02
ABC21378/07
ABC21378/08
ABC21378/31
i.e. each line is split after the "/" and concatenated with the starting string (before the first "/") to create a new sequence and put on separate rows.
ABC21256/03/04
ABC21311/01/09/11
ABC21313/02
ABC21378/07/08/31
into to this list:
ABC21256/03
ABC21256/04
ABC21311/01
ABC21311/09
ABC21311/11
ABC21313/02
ABC21378/07
ABC21378/08
ABC21378/31
i.e. each line is split after the "/" and concatenated with the starting string (before the first "/") to create a new sequence and put on separate rows.