Can anyone help with a formula to remove extra space at the end of a cell without removing the space in between words (like by using a find remove for space)
|word1 word2 BLANK SPACES|
Can anyone help with a formula to remove extra space at the end of a cell without removing the space in between words (like by using a find remove for space)
|word1 word2 BLANK SPACES|
Last edited by SEMMatt; 09-06-2012 at 09:12 PM.
try using
trim function
=trim(A1)
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
Yes, that worked. Thank you.
Your welcome.
Regards,
Vladimir
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks