How to remove dots

[Salamullah]

Hi all I have list of details have dots at the end I want formula to remove all please help me in this.


[TABLE="width: 115"]
<colgroup><col width="153" style="width: 115pt; mso-width-source: userset; mso-width-alt: 5595;"> <tbody>[TR]
[TD="width: 153, bgcolor: transparent, align: left"]Match Type . . . . . .[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: left"]Address Number ( # ) .[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: left"]Mailing Name . . . . .[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: left"]2nd Item Number. . . .[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: left"]Description. . . . . .[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: left"]Description 2. . . . .[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: left"]Order Number . . . . .[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: left"]Order Type . . . . . .[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: left"]Quantity . . . . . . .[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: left"]Quantity Paid to Date.[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: left"]Quantity Open. . . . .[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: left"]Quantity Received. . .[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: left"]Amount Paid to Date. .[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: left"]Amount Open. . . . . .[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: left"]Amount Received. . . .[/TD]
[/TR]
</tbody>[/TABLE]

 

[FormR]

Hi, maybe this will work for you:

Excel 2013/2016
	A	B
1	Match Type . . . . . .	Match Type
2	Address Number ( # ) .	Address Number ( # )
3	Mailing Name . . . . .	Mailing Name
4	2nd Item Number. . . .	2nd Item Number
5	Description. . . . . .	Description
6	Description 2. . . . .	Description 2
7	Order Number . . . . .	Order Number
8	Order Type . . . . . .	Order Type
9	Quantity . . . . . . .	Quantity
10	Quantity Paid to Date.	Quantity Paid to Date
11	Quantity Open. . . . .	Quantity Open
12	Quantity Received. . .	Quantity Received
13	Amount Paid to Date. .	Amount Paid to Date
14	Amount Open. . . . . .	Amount Open
15	Amount Received. . . .	Amount Received
Sheet1

Cell Formulas
Range	Formula
B1	=SUBSTITUTE(A1,".","")

Note, it removes all dots, not just those that appear at the end.

 

[AlanY]

Note, it removes all dots, not just those that appear at the end.

wouldn't be better to use the built-in function "find and replace" all .?

 

[FormR]

wouldn't be better to use the built-in function "find and replace" all .?

Maybe, but the OP specifically asked for a formula.

I want formula to remove all

 

[Salamullah]

Many thanks FormR the dot replace with spaces how can I remove that or please provide 1 formula for both

 

[miss_ell]

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

 

[FormR]

the dot replace with spaces how can I remove that

Hi, I'm sorry but I don't understand the question. Perhaps you can provide some before and after examples.