atw: Re: change case in Excel

I can't think how to do that directly, but there are 2 round about
ways...

 

1. Write a macro that applies the change to a specified or selected
column.

or

2. Create a new column next to the column you want to update.

  - In the first cell (after the heading) enter the  function you want -
upper or lower, there is also a "proper" case change, and fill down.

That by itself might be enough to solve your problem, but you could then
copy the new column and "paste special" and choose values only to update
the data in the original column.

 

Hope this helps.

Margaret

 

From: austechwriter-bounce@xxxxxxxxxxxxx
[mailto:austechwriter-bounce@xxxxxxxxxxxxx] On Behalf Of Rebecca
Caldwell
Sent: Tuesday, 7 July 2009 10:27 AM
To: austechwriter@xxxxxxxxxxxxx
Subject: atw: Re: change case in Excel

 

Sorry - how do I do this to an entire column?

 

Rebecca J

 

________________________________

From: austechwriter-bounce@xxxxxxxxxxxxx
[mailto:austechwriter-bounce@xxxxxxxxxxxxx] On Behalf Of David Godley
Sent: Tuesday, 7 July 2009 8:16 AM
To: austechwriter@xxxxxxxxxxxxx
Subject: atw: Re: change case in Excel

 

Upper()
Lower()



On Tue, Jul 7, 2009 at 9:42 AM, Rebecca Caldwell
<rebecca@xxxxxxxxxxxxxx> wrote:

Hi all, 

 

Does anyone know a simple way to change the case of text in an excel
spreadsheet by column? Someone told me there is a formula for this but I
cannot find it anywhere J

 

 


---
This email and any files transmitted with it are solely intended for the use of 
the addressee(s) and may contain information that is confidential and 
privileged.  If you receive this email in error, please advise us by return 
email immediately.  Please also disregard the contents of the email, delete it 
and destroy any copies immediately.
Computershare Limited and its subsidiaries do not accept liability for the 
views expressed in the email or for the consequences of any computer viruses 
that may be transmitted with this email.
This email is also subject to copyright.  No part of it should be reproduced, 
adapted or transmitted without the written consent of the copyright owner.

Other related posts: