ExcelBanter - now that i have formatted the text to "proper" ...

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - now that i have formatted the text to "proper" ... (https://www.excelbanter.com/excel-worksheet-functions/202439-now-i-have-formatted-text-proper.html)

catjea2000

now that i have formatted the text to "proper" ...

is there a way to remove the cells that are still in all caps without losing
the "proper" column?

Mike H

now that i have formatted the text to "proper" ...

Hi,

2 ways.

1. Hide the column with the capitalised words in.

or

2. Copy the 'Proper' colmn and paste it back over itself using
Edit|Paste special
paste values
then delete the capitalised column

Mike

"catjea2000" wrote:

is there a way to remove the cells that are still in all caps without losing
the "proper" column?

Gord Dibben

now that i have formatted the text to "proper" ...

Yes.

Copy the the column with the PROPER formulas.

EditPaste Special(in place)ValuesOKEsc.

Now delete the original column.

Gord Dibben MS Excel MVP

On Sat, 13 Sep 2008 11:46:01 -0700, catjea2000
wrote:

is there a way to remove the cells that are still in all caps without losing
the "proper" column?

All times are GMT +1. The time now is 03:59 PM.