JuicyMusic
Board Regular
- Joined
- Jun 13, 2020
- Messages
- 210
- Office Version
- 365
- Platform
- Windows
Hi, I hope someone can help.
I have a very long string of inventory part names in a cell. I don't know why our Inventory department enters all the parts that were used on one job in one cell instead of listing it in seperate rows.
I would like for the parts within this string to be listed vertically please, with a Macro.
1) Each part name within the string has a number, a ")", and a space before it.
Example: 2) Jack hammer, 5) Sprickets(silver) 2) Brooms 5736, 7) Ryobi Drill #6745(new), 4) Batteries (charged)
2) Some part names and part numbers may contain a "(" and/or a ")" anywhere within their name.
3) The number before the ")" stands for the quantity of that part that was used.
Example: 5) Sprickets (silver) means five silver sprickets were taken out of inventory.
RESULTS:
2) Jack Hammer
5) Sprickets(silver)
2) Brooms 5736
7) Ryobi Drill #6745(new)
4) Batteries (charged)
Is it possible to account for a typo, such as someone entering a "(" after the quantity number instead of a ")"? I see this typo often.
Example: 4( Batteries (charged)
Thank you so much.
Juicy
I have a very long string of inventory part names in a cell. I don't know why our Inventory department enters all the parts that were used on one job in one cell instead of listing it in seperate rows.
I would like for the parts within this string to be listed vertically please, with a Macro.
1) Each part name within the string has a number, a ")", and a space before it.
Example: 2) Jack hammer, 5) Sprickets(silver) 2) Brooms 5736, 7) Ryobi Drill #6745(new), 4) Batteries (charged)
2) Some part names and part numbers may contain a "(" and/or a ")" anywhere within their name.
3) The number before the ")" stands for the quantity of that part that was used.
Example: 5) Sprickets (silver) means five silver sprickets were taken out of inventory.
RESULTS:
2) Jack Hammer
5) Sprickets(silver)
2) Brooms 5736
7) Ryobi Drill #6745(new)
4) Batteries (charged)
Is it possible to account for a typo, such as someone entering a "(" after the quantity number instead of a ")"? I see this typo often.
Example: 4( Batteries (charged)
Thank you so much.
Juicy