Replace ( Ctrl + H ) without changing font color

[smallxyz]

Hi all,

I have a large bunch of cells ( 1,000+ ), each containing text symbol "．" and other colored texts.
I would like to remove all the "．" while remaining the texts colored. By using "Replace All ( Ctrl + H )", the "．" are removed. However, colored texts are also discolored.

Is there any way to handle this situation?

Thanks in advance!

 

[Khalid NGO]

Hi and welcome to the forum
Can you post your sample file here?
Meanwhile check if there is any CF applied for above mentioned symbol.

Symbols and texts are mixed or entered separately?
Regards,

 

[smallxyz]

Hi and welcome to the forum
Can you post your sample file here?
Meanwhile check if there is any CF applied for above mentioned symbol.

Symbols and texts are mixed or entered separately?
Regards,

Hi. Thanks for the welcoming
Attached the sample file. No CF. The symbols and texts are mixed.
Thank you, Khalid.

 

[bobhc]

I have you find and replace to remove the following three characters . [] and 【】,and the text colour remains the same.


.

 

[smallxyz]

A screen-print of my sample file.
Wanna delete only the　"．" text symbol while retaining the font color.

 

[smallxyz]

I have you find and replace to remove the following three characters . [] and 【】,and the text colour remains the same.


.

Thanks for the reply, bobhc.
What if I would like to reserve both [] 【】 and their corresponding font colors?

 

[Khalid NGO]

Hi,

I didn't found the way you required in excel, except the following way:
1) Copy/Paste your range to MS. Word
2) Use Find & Replace
3) Find what : ．
4) Replace with : (leave blank)
5) Replace all
6) copy/paste to excel.

Regards,

 

[Nebu]

Hi:

Find the attached . I have to use VBA to get this done.

Thanks