Following formula would be able to remove spaces from words in Excel,
=REPLACE(A1,LEN(A1),1,"")
Jacob Skaria wrote:
If that is a space the below will do.
02-Jun-10
If that is a space the below will do. Also note all double spaces within th
text also will be trimmed to a single space
=TRIM(A1
Still you see a character after text; then probably it may not be a space
Check that using the below formula..and replace the character usin
SUBSTITUTE(
=CODE(RIGHT(A1,1)
-
Jacob (MVP - Excel
:
Previous Posts In This Thread:
Submitted via EggHeadCafe - Software Developer Portal of Choice
Entity Framework 4.0 and the AJAX Autocomplete Extender.
http://www.eggheadcafe.com/tutorial...93a-b290f013f649/entity-framework-40-and.aspx