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.
|