Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
phshirk
 
Posts: n/a
Default how does one convert text to a formula "average(A:A)" to =average(

Would prefer not having to enter = manually in each cell.
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

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   Report Post  
Don Guillett
 
Posts: n/a
Default

excel formulas start with =

--
Don Guillett
SalesAid Software

"phshirk" wrote in message
...
Would prefer not having to enter = manually in each cell.



  #4   Report Post  
Jason Morin
 
Posts: n/a
Default

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   Report Post  
Gord Dibben
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to convert Excel imported numbers from text to numbers? Alden Excel Discussion (Misc queries) 9 April 1st 05 09:51 PM
How do I convert cells containing formulas to text (value returned Kim Excel Worksheet Functions 4 March 28th 05 09:17 PM
How to insert carriage return in the middle of a text formula to . Dave Excel Discussion (Misc queries) 2 March 17th 05 03:14 PM
Text formula c_prenderville Excel Worksheet Functions 2 March 15th 05 01:36 PM
Is there a formula to convert numbers to written text in Excel? LZC Excel Worksheet Functions 3 November 27th 04 09:10 PM


All times are GMT +1. The time now is 08:54 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"