Thanks Terry ! Have a nice weekend... (I'm in Qc,CA) BIGMARC === ----- Original Message ----- From: DavisUnit <davist@xxxxxxxxxxx> To: <pctechtalk@xxxxxxxxxxxxx> Sent: Thursday, May 12, 2005 8:46 AM Subject: -=PCTechTalk=- Re: Excel 97 Spreadsheet Help > 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 -- <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/