Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
bethye99
 
Posts: n/a
Default How can I change text to proper text in multiple cells.

I need to change names that are all in caps to proper case in 100 cells.
If I click each one individually, it works, but I need to be able to perfomr
this funcion automatically on all the cells. One other post said to be sure
calc is set to automatic and mine is. Any instruction is most appreciated.
Thank you.
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default How can I change text to proper text in multiple cells.

Insert a helper column to the right of the column with the names.

Then use a formula like:
=proper(a1)
and drag down that column

Then select that column
edit|copy
select the original range
Edit|paste special|Values

And then delete the helper column.

bethye99 wrote:

I need to change names that are all in caps to proper case in 100 cells.
If I click each one individually, it works, but I need to be able to perfomr
this funcion automatically on all the cells. One other post said to be sure
calc is set to automatic and mine is. Any instruction is most appreciated.
Thank you.


--

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
stopping pasted text deliminate across multiple cells Paul from NZ Excel Discussion (Misc queries) 3 September 8th 05 06:06 AM
Text shown up in other cells everytime a text is entered in 1 cell bioyyy Excel Discussion (Misc queries) 1 August 26th 05 05:26 PM
combine text of multiple cells Uncle O Excel Worksheet Functions 3 August 25th 05 05:09 PM
Cells formated as text do not always display properly Cass Excel Discussion (Misc queries) 2 July 23rd 05 01:59 AM
How can I change a text to a cell's address? Antônio Sobral Excel Discussion (Misc queries) 0 February 15th 05 05:55 PM


All times are GMT +1. The time now is 09:25 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"