-=PCTechTalk=- Re: Excel 97 Spreadsheet Help
- From: DavisUnit <davist@xxxxxxxxxxx>
- To: <pctechtalk@xxxxxxxxxxxxx>
- Date: Thu, 12 May 2005 9:46:17 -0300
Use the =UPPER formula
Example: Text you want to change is in column A, formula in column B, results
all in upper case would be displayed in column B.
A B
1 pc =upper(A1) PC
2 Tech =upper(A2) TECH
3 taLk =upper(A3) TALK
Terry
> From: "BIGMARC-SOFTHOME" <BIGMARC@xxxxxxxxxxxx>
> Date: 2005/05/12 Thu AM 02:45:17 ADT
> To: <pctechtalk@xxxxxxxxxxxxx>
> Subject: -=PCTechTalk=- Re: Excel 97 Spreadsheet Help
>
> Just want to know if its possible DIRECTY in Excel, and how ???
> BIGMARC
> BIGMARC
> ----- Original Message -----
> From: DavisUnit <davist@xxxxxxxxxxx>
> To: <pctechtalk@xxxxxxxxxxxxx>
> Sent: Wednesday, May 11, 2005 8:53 AM
> Subject: -=PCTechTalk=- Re: Excel 97 Spreadsheet Help
>
>
> > How about copy/paste over to Word, make the case change, then copy/paste
> back to Excel?
> >
> > Terry
> >
> > > From: "BIGMARC-SOFTHOME" <BIGMARC@xxxxxxxxxxxx>
> > > Date: 2005/05/11 Wed AM 12:53:04 ADT
> > > To: <pctechtalk@xxxxxxxxxxxxx>
> > > Subject: -=PCTechTalk=- Excel 97 Spreadsheet Help
> > >
> > > A simple question , in EXCEL (OFFICE 97 suite), is there a way , like in
> > > WORD, to change, in one step, headers or other text, from small letter
> to
> > > capital letter???
> > > Thanks for answerring !
> > > BIGMARC
>
>
--
<Please delete this line and everything below.>
To unsub or change your email settings:
//www.freelists.org/webpage/pctechtalk
To access our Archives:
http://groups.yahoo.com/group/PCTechTalk/messages/
//www.freelists.org/archives/pctechtalk/
Other related posts:
