Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how does one convert text to a formula "average(A:A)" to =average(
Would prefer not having to enter = manually in each cell.
|
#2
|
|||
|
|||
Edit|Replace
what: Average( with: =average( As long as Average( only occurs at the beginning of each cell in your selected area. It'll screw up on cells like: =if(a1=5,average(b1:b10),average(c1:c18)) phshirk wrote: Would prefer not having to enter = manually in each cell. -- Dave Peterson |
#3
|
|||
|
|||
excel formulas start with =
-- Don Guillett SalesAid Software "phshirk" wrote in message ... Would prefer not having to enter = manually in each cell. |
#4
|
|||
|
|||
Assuming your "formulas" w/out equal signs are in column
A... 1. Insert this into row 1 of an open col. (say col. B) and fill down: ="="&A1 2. Select col. B, copy it, and go to Edit Paste Special Value. 3. Press Ctrl+H and fill in: Find What: = Replace With: = HTH Jason Atlanta, GA -----Original Message----- Would prefer not having to enter = manually in each cell. . |
#5
|
|||
|
|||
You can employ a UDF.
Function EvalCell(RefCell As String) Application.Volatile EvalCell = Evaluate(RefCell) End Function With the text average(A:A) in B1 enter =EvalCell(B1) in C1 Would seem to me however that typing an = sign would be easier than entering/copying a bunch of formulas. Unless you have the text pre-entered and are looking to change to a formula. Gord Dibben Excel MVP On Wed, 13 Apr 2005 16:52:04 -0700, "phshirk" wrote: Would prefer not having to enter = manually in each cell. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to convert Excel imported numbers from text to numbers? | Excel Discussion (Misc queries) | |||
How do I convert cells containing formulas to text (value returned | Excel Worksheet Functions | |||
How to insert carriage return in the middle of a text formula to . | Excel Discussion (Misc queries) | |||
Text formula | Excel Worksheet Functions | |||
Is there a formula to convert numbers to written text in Excel? | Excel Worksheet Functions |