View Single Post
  #12   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Munfarid Munfarid is offline
external usenet poster
 
Posts: 10
Default How to remove space from a cell.

opps. please

May be the following will help you to understand the issue:

The cell A1 contain "4353495894385 ".

When i use the formula =LEN(A1), the result is "18" but when i use the
formula =SUBSTITUTE(A1," ",""), the result is also comes at '18'. The result
should rather be '13'. This indicates that the later portion of the
numberstring is appeared to be 'spaces' which the substitute formula is not
recognising.

I hope you got my point. If not, please advise.