Hi all,

I have a series of strings of text in cell A3 etc which look like this
$PSCMSM2,172946.00,V,HT,4,H,33.13,79*38

and i am using this formula to retrieve the 5 numbers(characters) after the H, (in this case 33.13)

=IF(MID($A3,24,LEN(AV$1))=AV$1,(MID($A3,29,5)),"")

but every now and then i get strings where instead of 5 characters after the H, i get 4

eg $PSCMSM2,172946.00,V,HT,4,H,43.1,79*38

and the output is 43.1,
How can i use the REPLACE function within my existing formula to replace the commas with nothing so i get a pure number?

Thanks,

C.