daltendavis
New Member
- Joined
- Jun 26, 2018
- Messages
- 37
For example I would paste in A1:
995
950-993
*995-118
118
790-118
I want it to return on a separate sheet:
995 2
950 1
993 1
118 3
790 1
Right now I have it coming back as exactly what is pasted in the cell and cannot figure it out what so ever.
Thank you for your help.
EDIT:
Also forgot to mention, like the *995 in the example some entries have an astrix in front of them it is split with another store. Thanks again
995
950-993
*995-118
118
790-118
I want it to return on a separate sheet:
995 2
950 1
993 1
118 3
790 1
Right now I have it coming back as exactly what is pasted in the cell and cannot figure it out what so ever.

Thank you for your help.
EDIT:
Also forgot to mention, like the *995 in the example some entries have an astrix in front of them it is split with another store. Thanks again
Last edited by a moderator: