software

I have a spreadsheet with data containing UPPERCASE. I need to use the
PROPER formual and do not know where to enter this formula on the spreadsheet.

You would enter the formula where you want the results to appear. If, for
instance, you want to change all of column A from uppercase to proper, insert
a column before column B. In B1 enter =proper(A1). Copy that formula down
through column A. Then copy/paste special values. Finally, delete column A
if you don't want to keep it around.

quot;Colleen Littlequot; wrote:

gt; I have a spreadsheet with data containing UPPERCASE. I need to use the
gt; PROPER formual and do not know where to enter this formula on the spreadsheet.

So I have a large spreadsheet I need to do this on. I would insert a new
column for each column in this spreadsheet. Column A I need to take Cells 3
thru 270 and change to PROPER. What would the formula be for that
=PROPER(A3:A270)? This formula would get inserted into the newly created
column between A and B?

quot;bpeltzerquot; wrote:

gt; You would enter the formula where you want the results to appear. If, for
gt; instance, you want to change all of column A from uppercase to proper, insert
gt; a column before column B. In B1 enter =proper(A1). Copy that formula down
gt; through column A. Then copy/paste special values. Finally, delete column A
gt; if you don't want to keep it around.
gt;
gt; quot;Colleen Littlequot; wrote:
gt;
gt; gt; I have a spreadsheet with data containing UPPERCASE. I need to use the
gt; gt; PROPER formual and do not know where to enter this formula on the spreadsheet.

I wouldn't use more than one cell as input to the proper function. In B3,
enter =proper(A3) and copy that formula from B3 into B4:B270.
If you have a bunch of columns on which to do this (hopefully less than
129), I'd go to the first empty column and enter the function there,
=proper(a3). Copy down to the last row of data, and across for as many
columns of data as you've got. Then copy/paste special values all the
columns at once.

quot;Colleen Littlequot; wrote:

gt; So I have a large spreadsheet I need to do this on. I would insert a new
gt; column for each column in this spreadsheet. Column A I need to take Cells 3
gt; thru 270 and change to PROPER. What would the formula be for that
gt; =PROPER(A3:A270)? This formula would get inserted into the newly created
gt; column between A and B?
gt;
gt; quot;bpeltzerquot; wrote:
gt;
gt; gt; You would enter the formula where you want the results to appear. If, for
gt; gt; instance, you want to change all of column A from uppercase to proper, insert
gt; gt; a column before column B. In B1 enter =proper(A1). Copy that formula down
gt; gt; through column A. Then copy/paste special values. Finally, delete column A
gt; gt; if you don't want to keep it around.
gt; gt;
gt; gt; quot;Colleen Littlequot; wrote:
gt; gt;
gt; gt; gt; I have a spreadsheet with data containing UPPERCASE. I need to use the
gt; gt; gt; PROPER formual and do not know where to enter this formula on the spreadsheet.

Thank you! This works great.

quot;bpeltzerquot; wrote:

gt; You would enter the formula where you want the results to appear. If, for
gt; instance, you want to change all of column A from uppercase to proper, insert
gt; a column before column B. In B1 enter =proper(A1). Copy that formula down
gt; through column A. Then copy/paste special values. Finally, delete column A
gt; if you don't want to keep it around.
gt;
gt; quot;Colleen Littlequot; wrote:
gt;
gt; gt; I have a spreadsheet with data containing UPPERCASE. I need to use the
gt; gt; PROPER formual and do not know where to enter this formula on the spreadsheet.

Yes, that is exactly what I did. Now my issue is I need to import this data
into QuickBooks which I do have knowlege in but when I try to delete the
quot;oldquot; rows in excel which houses the original data it wipes out the new row.
When I copy past the new rows into a new sheet I get the quot;XREF!quot; error and
cannot find documentation on how to correct that.

quot;bpeltzerquot; wrote:

gt; I wouldn't use more than one cell as input to the proper function. In B3,
gt; enter =proper(A3) and copy that formula from B3 into B4:B270.
gt; If you have a bunch of columns on which to do this (hopefully less than
gt; 129), I'd go to the first empty column and enter the function there,
gt; =proper(a3). Copy down to the last row of data, and across for as many
gt; columns of data as you've got. Then copy/paste special values all the
gt; columns at once.
gt;
gt; quot;Colleen Littlequot; wrote:
gt;
gt; gt; So I have a large spreadsheet I need to do this on. I would insert a new
gt; gt; column for each column in this spreadsheet. Column A I need to take Cells 3
gt; gt; thru 270 and change to PROPER. What would the formula be for that
gt; gt; =PROPER(A3:A270)? This formula would get inserted into the newly created
gt; gt; column between A and B?
gt; gt;
gt; gt; quot;bpeltzerquot; wrote:
gt; gt;
gt; gt; gt; You would enter the formula where you want the results to appear. If, for
gt; gt; gt; instance, you want to change all of column A from uppercase to proper, insert
gt; gt; gt; a column before column B. In B1 enter =proper(A1). Copy that formula down
gt; gt; gt; through column A. Then copy/paste special values. Finally, delete column A
gt; gt; gt; if you don't want to keep it around.
gt; gt; gt;
gt; gt; gt; quot;Colleen Littlequot; wrote:
gt; gt; gt;
gt; gt; gt; gt; I have a spreadsheet with data containing UPPERCASE. I need to use the
gt; gt; gt; gt; PROPER formual and do not know where to enter this formula on the spreadsheet.

Be sure to lock in the values before deleting the old data. Highlight the
transformed data all at once, then Copy (ctrl c) and Edit gt; Paste Special,
select the Values radio button and click OK. (You could paste over the
transformed data, or you could follow the same steps to paste into a new
worksheet).

quot;Colleen Littlequot; wrote:

gt; Yes, that is exactly what I did. Now my issue is I need to import this data
gt; into QuickBooks which I do have knowlege in but when I try to delete the
gt; quot;oldquot; rows in excel which houses the original data it wipes out the new row.
gt; When I copy past the new rows into a new sheet I get the quot;XREF!quot; error and
gt; cannot find documentation on how to correct that.
gt;
gt; quot;bpeltzerquot; wrote:
gt;
gt; gt; I wouldn't use more than one cell as input to the proper function. In B3,
gt; gt; enter =proper(A3) and copy that formula from B3 into B4:B270.
gt; gt; If you have a bunch of columns on which to do this (hopefully less than
gt; gt; 129), I'd go to the first empty column and enter the function there,
gt; gt; =proper(a3). Copy down to the last row of data, and across for as many
gt; gt; columns of data as you've got. Then copy/paste special values all the
gt; gt; columns at once.
gt; gt;
gt; gt; quot;Colleen Littlequot; wrote:
gt; gt;
gt; gt; gt; So I have a large spreadsheet I need to do this on. I would insert a new
gt; gt; gt; column for each column in this spreadsheet. Column A I need to take Cells 3
gt; gt; gt; thru 270 and change to PROPER. What would the formula be for that
gt; gt; gt; =PROPER(A3:A270)? This formula would get inserted into the newly created
gt; gt; gt; column between A and B?
gt; gt; gt;
gt; gt; gt; quot;bpeltzerquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; You would enter the formula where you want the results to appear. If, for
gt; gt; gt; gt; instance, you want to change all of column A from uppercase to proper, insert
gt; gt; gt; gt; a column before column B. In B1 enter =proper(A1). Copy that formula down
gt; gt; gt; gt; through column A. Then copy/paste special values. Finally, delete column A
gt; gt; gt; gt; if you don't want to keep it around.
gt; gt; gt; gt;
gt; gt; gt; gt; quot;Colleen Littlequot; wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; gt; I have a spreadsheet with data containing UPPERCASE. I need to use the
gt; gt; gt; gt; gt; PROPER formual and do not know where to enter this formula on the spreadsheet.