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.:confused:
Thank you for your...