ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   change text case of some selected words from formula bar. (https://www.excelbanter.com/excel-programming/343436-change-text-case-some-selected-words-formula-bar.html)

al

change text case of some selected words from formula bar.
 
Can anybody tell me how to change text case of some selected words from
formula bar.(not all words in cell)


Dave Peterson

change text case of some selected words from formula bar.
 
Retype them?
(Not what you wanted to hear--but excel doesn't have that same kind of
format|change case that MSWord has.)

al wrote:

Can anybody tell me how to change text case of some selected words from
formula bar.(not all words in cell)


--

Dave Peterson

Kenneth Hobson

change text case of some selected words from formula bar.
 
I gather you mean the formula in the active cell?

Do like you do any selected text in the cell. It is not reflected in the
formula bar but is reflected in the cell. It is easy to select the word or
text in the formula bar and then do the changes by clicking the applicable
button of the Formatting toolbar.

Most that do such would probably doubleclick the cell and do the
modifications there.



al

change text case of some selected words from formula bar.
 
That's what I thought - but I wanted confirmation from an expert.
Thxs

Dave Peterson wrote:
Retype them?
(Not what you wanted to hear--but excel doesn't have that same kind of
format|change case that MSWord has.)

al wrote:

Can anybody tell me how to change text case of some selected words from
formula bar.(not all words in cell)


--

Dave Peterson




All times are GMT +1. The time now is 07:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com