Morning all!
I'm having issue with something that I think should be pretty simple.
I am trying to extract numbers before, in-between, and after two "/" symbols in a serial number.
In A1 I have serial numbers that follow the example below:
1/2/3
Any of these digits can be either single or double (i.e. 10/2/3, 1/20/30)
The desired result is the following:
10/2/3 A 10 B 2 C 3
So far I've managed to get the results for rows A and B to work regardless of number of digits; but I'm having difficulty with getting row C to work.
For row C, I tried to usebut the result returns "/3".Please Login or Register to view this content.
Obviously I don't want the "/" to appear in the result.
Any help you can offer is greatly appreciated. =)
Bookmarks