Substitute formula

Hi Iwona, thanks for your query. I put your text "PHPH. SG1519. 6303" into cell A1 and used:

=SUBSTITUTE(A1, ". ", "")

in cell A2 to remove the full stop. Note, your text also included a space after the full stop so I included that in the substitution text as well. There's a useful walkthrough of the function here:

http://www.bettersolutions.com/excel/EDH113/LU015931611.htm

Hope this helps,

Anthony