Help in removing multiple random amounts of periods

[DougStroud]

I need help in removing periods from a series of cells.

Example:

Columbia-Barnard.........................

Duke.............................

<colgroup><col style="mso-width-source:userset;mso-width-alt:8618;width:202pt" width="202"> </colgroup><tbody>
</tbody>

<style>table { }td { padding-top: 1px; padding-right: 1px; padding-left: 1px; color: black; font-size: 12pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Calibri, sans-serif; vertical-align: bottom; border: medium none; white-space: nowrap; }</style>

I tried find/replace all and that did not work.

 

[sheetspread]

Replace it with nothing, that didn't work?

 

[DougStroud]

Replace it with nothing, that didn't work?

No, that did not work

 

[dave2018]

If your Data is in Column A, put the following formula in B1 and copy down the length of your data in column A

=SUBSTITUTE(SUBSTITUTE(A1,CHAR(133),""),CHAR(46),"")

Explanation:

Char(46) = .
Char(133) = ... (3 periods in a row that get generated when u type them in microsoft word or excel... and they are considered as 1 (not 3) charachter)

I think that this may be what you are looking for.

 

[DougStroud]

If your Data is in Column A, put the following formula in B1 and copy down the length of your data in column A

=SUBSTITUTE(SUBSTITUTE(A1,CHAR(133),""),CHAR(46),"")

Explanation:

Char(46) = .
Char(133) = ... (3 periods in a row that get generated when u type them in microsoft word or excel... and they are considered as 1 (not 3) charachter)

I think that this may be what you are looking for.

Dude- You Rock! Thank you so much!!!!

 

[dave2018]

My Pleasure!