Hey, nice info...but it doesn't work in case of
AB CD ---> ABCD (It only converts multiple spaces to single space)
--
Regards,
Nihar Taranekar
Regards,
Nihar Taranekar
'LOOK' Back and get Experience..!
'LOOK' Forward and see Hope..!
'LOOK' Around and find Reality..!
'LOOK' Within and find confidence
'LOOK' Forward and see Hope..!
'LOOK' Around and find Reality..!
'LOOK' Within and find confidence
On Tue, Apr 16, 2013 at 11:20 AM, Junaid Tahir <mjunaidtahir@gmail.com> wrote:
This function is helpful to remove the unnecessary spaces from cell fields…--ExampleOriginal TextTrimmed Text
ABCDABCD=TRIM(C4)
A B C DABCD=TRIM(C5)
Alan JonesAlan 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
Syntax
=TRIM(TextToTrim)Formatting
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.
--
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