Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
al al is offline
external usenet poster
 
Posts: 64
Default 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)

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default 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
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default 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.


  #4   Report Post  
Posted to microsoft.public.excel.programming
al al is offline
external usenet poster
 
Posts: 64
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do i change the words from lower case to uppercase/capitals dm Excel Discussion (Misc queries) 3 July 17th 09 09:34 AM
Cannot change text to proper case using formula LaDena Excel Worksheet Functions 2 December 18th 07 05:33 PM
Can you change letter case without having to retype words? Elissa Excel Discussion (Misc queries) 4 May 30th 07 06:07 AM
change text case in excel without using formula like word? Shahid Ghafoor Mughal Excel Discussion (Misc queries) 2 September 19th 06 03:02 PM
Change the text from lower case to upper case in an Excel work boo dave01968 Excel Discussion (Misc queries) 2 December 9th 05 09:09 AM


All times are GMT +1. The time now is 06:01 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"