Forum home » Delegate support and help forum » Microsoft Excel Training and help » Substitute formula
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Substitute formula
Resolved · Low Priority · Version 2010
Reply Tue 10 Jan 2012, 17:25Delegate Iwona said...
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
For upcoming training course dates see: Pricing & availability
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
Wed 18 Jan 2012: Automatically marked as resolved.
|