Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
substitute formula

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Substitute formula

Substitute formula

ResolvedVersion 2010

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

Wed 18 Jan 2012: Automatically marked as resolved.

Excel tip:

Activating the formula bar with the keyboard in Excel 2010

The formula bar in Excel 2010 contains a number of different formulas. However, it is time consuming to open the formula bar every time and insert the formula using the mouse. Instead, you can activate the formula bar with the keyboard. Simply press the F2 button on the keyboard then the information in the cell will expand allowing you to edit the information in the cell.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.