i-nth - SUBSTITUTE for space removal - another way to TRIM!

SUBSTITUTE for space removal - another way to TRIM!

27 April 2013

The SUBSTITUTE function is an easy way to replace characters in an entry with something else. Here is an example of a cell with data entered...

Full article: Not available

Essential reading

Bibliography

See our bibliography of spreadsheet best practice, risk management, errors and testing, and methods for improving spreadsheets.

Latest articles

Consulting

We can help you make better spreadsheets:

Reviewing your spreadsheets for errors.
Advice about improving your spreadsheets.
Training in spreadsheet good practice.