Booklet

author

John Michaloudis

Office Productivity

Text Manipulation Guide Excel Formulas Tips & Tricks

Text Manipulation Guide - Excel Formulas Tips & Tricks!

1. TRIM

Remove Extra Spaces

Example:

wrong: too many spaces

right: too many spaces

2. LEN

Counts number of characters

Example:

MyExcelOnline!

3. CONCATENATE

Combines two or more text

Example:

Join + Me + Together

Join Me Together

More booklets by John Michaloudis

More Office Productivity booklets

Your recently viewed booklets

  • booklet-slide-images
  • booklet-slide-images
  • booklet-slide-images
  • booklet-slide-images
  • booklet-slide-images
  • booklet-slide-images
  • booklet-slide-images
  • booklet-slide-images
  • booklet-slide-images
  • booklet-slide-images
See all booklets