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.

Match Type . . . . . .

Address Number ( # ) .

Mailing Name . . . . .

2nd Item Number. . . .

Description. . . . . .

Description 2. . . . .

Order Number . . . . .

Order Type . . . . . .

Quantity . . . . . . .

Quantity Paid to Date.

Quantity Open. . . . .

Quantity Received. . .

Amount Paid to Date. .

Amount Open. . . . . .

Amount Received. . . .

<colgroup><col width="153" style="width: 115pt; mso-width-source: userset; mso-width-alt: 5595;"> <tbody> </tbody>

 

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