|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
October 14th, 2004, 01:59 PM
|
|||
|
|||
formula to convert a worksheet from upper case to proper
I'm having difficulty with the formula to convert my worksheet form upper
case to proper. I'm using =PROPER(A2:A102), but it's creating a circular reference and i'm not sure how to get around that. Please help!!!!!! 
|
|
#2
October 14th, 2004, 02:04 PM
|
|||
|
|||
|
That is probably because you formula is in one of those cells, so it is
trying to refer to itself. Put =PROPER(A2) in cell B2, copy down to B102, Copy B2:B102, goto EditPasteSpecial, and select Values, OK, then delete column A. -- HTH RP "Nancy Cantave" Nancy wrote in message ... I'm having difficulty with the formula to convert my worksheet form upper case to proper. I'm using =PROPER(A2:A102), but it's creating a circular reference and i'm not sure how to get around that. Please help!!!!!!
|
|
#3
October 14th, 2004, 02:12 PM
|
|||
|
|||
|
Hi
see: http://www.cpearson.com/excel/case.htm you'll need VBA to do this -- Regards Frank Kabel Frankfurt, Germany Nancy Cantave wrote: I'm having difficulty with the formula to convert my worksheet form upper case to proper. I'm using =PROPER(A2:A102), but it's creating a circular reference and i'm not sure how to get around that. Please help!!!!!!
|
|
#4
October 14th, 2004, 02:21 PM
|
|||
|
|||
|
You are awesome Bob!!! It worked. Thank you for taking the time to respond.
"Bob Phillips" wrote: That is probably because you formula is in one of those cells, so it is trying to refer to itself. Put =PROPER(A2) in cell B2, copy down to B102, Copy B2:B102, goto EditPasteSpecial, and select Values, OK, then delete column A. -- HTH RP "Nancy Cantave" Nancy wrote in message ... I'm having difficulty with the formula to convert my worksheet form upper case to proper. I'm using =PROPER(A2:A102), but it's creating a circular reference and i'm not sure how to get around that. Please help!!!!!!
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Arghhh - can't convert text font to Upper CASE | DianaH | New Users | 5 | September 28th, 2004 11:21 PM |
| how to change proper text to upper case text | dj | New Users | 1 | September 21st, 2004 10:41 PM |
| check writing code | funkmaster22 | Using Forms | 2 | August 11th, 2004 09:35 PM |
| Referencing a worksheet in a formula | Gary H | Worksheet Functions | 2 | September 26th, 2003 05:17 AM |
Linear Mode
