Thread: Excel help needed
View Single Post
  #2  
Old 28th January 2009, 06:05 PM
stugots stugots is offline
Banned
  
Join Date: Jan 1970
Posts: 879
Default
'substitute' may help if the data is all in one cell

=SUBSTITUTE(A1," ","")

if the data is spread over several cells then combing them into one & then using 'substitute' should work
Reply With Quote