Wizard’s tips by email
Search this site
Topics
- Advice (11)
- Formulae explained (12)
- General (8)
- How to (33)
- Quick tips (18)
- Tools (8)
- Uncategorized (5)
Tags
- ADDRESS
- CLEAN
- CONCATENATE
- Conditional format
- copy
- COUNTIF
- COUNTIFS
- Custom View
- cut
- Data import
- Dollars
- Editing
- EXACT
- Fill
- filter
- Format
- Formulae
- Frequency
- HLOOKUP
- IF
- INDIRECT
- LEFT
- Mail Merge
- MID
- MIN
- MOD
- Navigation
- paste
- Paste Special
- PivotTable
- PivotTables
- RANK
- RIGHT
- ROUNDDOWN
- ROUNDUP
- Series
- Shortcut
- SMALL
- SUM
- SUMIF
- SUMIFS
- Text to columns
- TRIM
- VLOOKUP
- WEEKDAY
Tag Archives: TRIM
TRIM
Summary This is an oft forgotten function. Quite simply, it gets rid of unwanted spaces. It does so in the following ways. All leading spaces that appear at the start of the cell being trimmed are removed All trailing spaces … Continue reading