atw: Re: change case in Excel
- From: "Rebecca Caldwell" <rebecca@xxxxxxxxxxxxxx>
- To: <austechwriter@xxxxxxxxxxxxx>
- Date: Tue, 7 Jul 2009 09:42:49 +0800
Done!
Thanks for that!
________________________________
From: austechwriter-bounce@xxxxxxxxxxxxx
[mailto:austechwriter-bounce@xxxxxxxxxxxxx] On Behalf Of Rebecca
Caldwell
Sent: Tuesday, 7 July 2009 9:36 AM
To: austechwriter@xxxxxxxxxxxxx
Subject: 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:
