View Single Post
  #1   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.

Hi there,

Could anyone please advise how to remove 'spaces' that are contained within
a number string in a cell?

e.g. 123 4545 4545

Please advise how to remove the spaces in between, with any function/formula
to obtain the desired result of '12345454545' i.e. by deleting the spaces.

Thanks