Blackie50
03-30-2012, 03:58 AM
Hi,
Been trying to change the following
14/5542715-6/P to
5542715P6
Ahve the following =MID(K1,4,LEN(K1)-8)&RIGHT(K1,1) which captures
5542715 but struggling with adding the other bits to it. There should be no gaps in the converted string.
Please help
thanks
Jon
Been trying to change the following
14/5542715-6/P to
5542715P6
Ahve the following =MID(K1,4,LEN(K1)-8)&RIGHT(K1,1) which captures
5542715 but struggling with adding the other bits to it. There should be no gaps in the converted string.
Please help
thanks
Jon