This function is helpful to remove the unnecessary spaces from cell fields…
AB CD ABCD =TRIM(C4)
A B C D ABCD =TRIM(C5)
Alan Jones Alan Jones =TRIM(C6)
What Does It Do ?
This function removes unwanted spaces from a piece of text.
The spaces before and after the text will be removed completely.
Multiple spaces within the text will be trimmed to a single space
=TRIM(TextToTrim)
Formatting
No special formatting is needed.
-- Example
Original Text Trimmed Text
AB
A B C D
Alan Jones
This function removes unwanted spaces from a piece of text.
The spaces before and after the text will be removed completely.
Multiple spaces within the text will be trimmed to a single space
Syntax
=TRIM(TextToTrim)
No special formatting is needed.
--
We are also on Face Book, Click on Like to jois us
FB Page: https://www.facebook.com/pages/Hyderabad-Masti/335077553211328
FB Group: https://www.facebook.com/groups/hydmasti/
https://groups.google.com/d/msg/hyd-masti/GO9LYiFoudM/TKqvCCq2EbMJ
---
You received this message because you are subscribed to the Google Groups "Hyderabad Masti" group.
To unsubscribe from this group and stop receiving emails from it, send an email to hyd-masti+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
No comments:
Post a Comment