MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Text Function ( proper) Question


Posted by Mark on March 14, 2001 7:11 AM

This function requires the text to be surrounded by quotes.."MARK", my text doesnt have the quotes around it, any suggestions would be great, thank you


Posted by Dave Hawley on March 14, 2001 7:17 AM

Mark, I'm not too sure I understand you, but this formula will Proper the content of A4

=PROPER(A4)

This one will Proper your name
=PROPER("mArK")


Dave

OzGrid Business Applications

Posted by Mark on March 14, 2001 7:39 AM

Thanks for the answer but my text does not have quotes around it, so the fuction didnt work, for example the text is the like this COMPAQ COMPUTERS and not "COMPAQ COMPUTERS"....ie no quotes. Excel does not excute the function without the quotes and therefore doesnt work on my speadsheet..hope thats clearer..perhaps there is an answer....thank you

Posted by Dave Hawley on March 14, 2001 7:50 AM


Mark, you have confused me even further!

If you text resides in a cell, you wont need Quotes! Just use: =PROPER(A4)
A4 is a cell address

If your text is not in a cell then simply enclose it in quotes: =PROPER("COMPAQ COMPUTERS")

Your result will be:
Compaq Computers
With NO quotes.


Dave

OzGrid Business Applications

Posted by Mark on March 14, 2001 8:01 AM

Re: Question 1500 rows and 15 colmuns

Dave thanks, but I have 1500 rows and 15 colmuns, so I cant do this manually...is there a way to make the fuction work

Posted by Dave on March 14, 2001 8:15 AM

Re: Question 1500 rows and 15 colmuns

Mark, Yes!

On another sheet use this formula in cell A1:
=PROPER(Sheet1!A1)
Copy this across 15 Columns.
Then down 1500 rows.

Push Ctrl+A to select the entire sheet.
Push Ctrl+C to copy
Go to Edit>PasteSpecial-Values

Dave
OzGrid Business Applications

Posted by Mark on March 14, 2001 9:09 AM

Help !!!!!

I am sorry this is not working for me I am getting the same single word repeated all over that happens to be cell sheet a1

Posted by Dave Hawley on March 14, 2001 9:16 AM

Re: Help !!!!!


Mark, you probably have:

=PROPER(Sheet1!$A$1)

Instead of

=PROPER(Sheet1!A1)


Dave


OzGrid Business Applications

Posted by mark on March 14, 2001 9:17 AM

Help !!!!!Re: Question 1500 rows and 15 colmuns

this is isnt working for me ..whenI triedit it excel repeated the same word over the spreadsheet, the text in a1

Posted by mark on March 14, 2001 9:25 AM

Again ..Re: Help !!!!!

Dave thanks for the help but heres what I have exactly
=PROPER(Sheet1!A1)
it merge the cell across to colmun L
I copied this down the rest of the blank speadsheet, which produced a 0 in each cell. I tried copy it anyway and paste special, values into the sheet 1 and it just produced 0 s all over

thanks for the help

Posted by Dave Hawley on March 14, 2001 9:31 AM

Re: Again ..Re: Help !!!!!


"Sheet1" is only an example. Use your actual sheet name.


Dave

OzGrid Business Applications

Posted by mark on March 14, 2001 9:39 AM

sheet name

sheet1 is the name of the sheet

Posted by Mark A on March 14, 2001 1:52 PM

help ...sheet name was correct

Sheet name was sheet1

Posted by Mark on March 14, 2001 7:18 PM

IT WORKED !!!! MANY THANKS