Iwona has attended:
Excel Intermediate course
Excel Intermediate course
Substitute formula
How do I remove dots between numbers by using the formulae for substitution?
PHPH. SG1519. 6303
Thanks
RE: 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