atw: Re: change case in Excel

Thanks Margaret, 

 

Gives me something to work with! I learnt excel a long time ago and my
brain is not cooperating with its logic!

 

Rebecca

 

________________________________

From: austechwriter-bounce@xxxxxxxxxxxxx
[mailto:austechwriter-bounce@xxxxxxxxxxxxx] On Behalf Of Margaret
Hassall
Sent: Tuesday, 7 July 2009 9:34 AM
To: austechwriter@xxxxxxxxxxxxx
Subject: 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 :-)

 

________________________________

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 :-)

 

 

--- 

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: