Home |
Search |
Today's Posts |
#1
|
|||
|
|||
PROPER function
I need to apply the PROPER function to an entire worksheet that has a few
thousand cell entries. I have two problems in accomplishing this: First, I can't format more than one column- and I'm only able to that using the fill-handle. For some reason, trying to do this as a traditional function like this: =proper(cell:cell), is not working. Second, I end up with two sets of data- one formatted and one not. I need the function to be 'underneath' the data. Is there a way to write one function for the entire worksheet, and have it applied to the entire worksheet and not as a new set of data? Appreciate any help, Danielle |
#2
|
|||
|
|||
Hi, Danielle. You could insert a column, type =Proper(b2) (notice I did not
use a range...it only works one cell at a time), and copy it down. Select all the cells with the new function in them. Copy. (don't move!) Edit--Paste special, Values, OK. Then delete the original column. Alternatively, you can use a macro: http://www.officearticles.com/excel/...ft_exce l.htm ************ Anne Troy www.OfficeArticles.com "Danielle via OfficeKB.com" <u14899@uwe wrote in message news:55d79d571407c@uwe... I need to apply the PROPER function to an entire worksheet that has a few thousand cell entries. I have two problems in accomplishing this: First, I can't format more than one column- and I'm only able to that using the fill-handle. For some reason, trying to do this as a traditional function like this: =proper(cell:cell), is not working. Second, I end up with two sets of data- one formatted and one not. I need the function to be 'underneath' the data. Is there a way to write one function for the entire worksheet, and have it applied to the entire worksheet and not as a new set of data? Appreciate any help, Danielle |
#3
|
|||
|
|||
Use the macro from here
http://www.mvps.org/dmcritchie/excel/proper.htm#proper Regards, Peo Sjoblom "Danielle via OfficeKB.com" <u14899@uwe wrote in message news:55d79d571407c@uwe... I need to apply the PROPER function to an entire worksheet that has a few thousand cell entries. I have two problems in accomplishing this: First, I can't format more than one column- and I'm only able to that using the fill-handle. For some reason, trying to do this as a traditional function like this: =proper(cell:cell), is not working. Second, I end up with two sets of data- one formatted and one not. I need the function to be 'underneath' the data. Is there a way to write one function for the entire worksheet, and have it applied to the entire worksheet and not as a new set of data? Appreciate any help, Danielle |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing worksheet cells from within a function | Setting up and Configuration of Excel | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
Custom Function | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
Find a Function to use accross different worksheets | Excel Worksheet Functions |