Is there any built-in function that remove the character space?
A Anne Troy Nov 8, 2005 #2 Find and replace? Ctrl+H. Put a space in the find what and don't put anything in the replace with. ************ Anne Troy www.OfficeArticles.com
Find and replace? Ctrl+H. Put a space in the find what and don't put anything in the replace with. ************ Anne Troy www.OfficeArticles.com
R Ron Rosenfeld Nov 9, 2005 #4 Is there any built-in function that remove the character space? Click to expand... =SUBSTITUTE(A1," ","") --ron
Is there any built-in function that remove the character space? Click to expand... =SUBSTITUTE(A1," ","") --ron