microsoft excel training in london - trim function

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel training in london - Trim function

microsoft excel training in london - Trim function

resolvedResolved · Low Priority · Version Standard

George has attended:
Excel Advanced course

Trim function

Can you explain what this function does/ what's its use as well as what is the syntax of it?

Thanks

RE: Trim function

HI George

TRIM

Removes all spaces from text except for single spaces between words. Use TRIM on text that you have received from another application that may have irregular spacing.

Syntax

TRIM(text)

Text is the text from which you want spaces removed.


regards


Richard


 

Excel tip:

Navigate with keyboard without losing your active cell

If you like using your keyboard to scroll through your excel document, but want to keep your active cell the same, use the scroll lock, and then use your arrow keys to navigate around the document.

View all Excel hints and tips


Server loaded in 0.08 secs.