PDA

View Full Version : Solved: Change text string



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

Bob Phillips
03-30-2012, 06:32 AM
Try this

=SUBSTITUTE(MID(A2,FIND("/",A2)+1,FIND("/",A2,FIND("/",A2)+1)-FIND("/",A2)-1),"-",RIGHT(A2))

Blackie50
03-30-2012, 07:08 AM
Excellent work - thanks a lot

regards
jon