Thread: How to create a formula to remove multiple . in a numbers?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Glenn Glenn is offline
external usenet poster
  
Posts: 1,240
Default How to create a formula to remove multiple . in a numbers?
Cheri.l wrote:
Ex: 11.2101.1030.0000.0000.1982 how can I remove these dots in multiple
numbers on a spreadsheet?

You can remove the "dots" with SUBSTITUTE:

=SUBSTITUTE(A1,".","")

The result is still text that looks like a number, but due to the length of the
string, it isn't going to be much good as a number, anyway.
Reply With QuoteReply With Quote