average formal if cell contains number and text

		Microsoft Office Forums > Microsoft Excel > Excel
average formal if cell contains number and text

FAQ

Mark Forums Read

Thread Tools

Display Modes

12-08-2016, 02:17 AM

Michael Labuschagne Michael Labuschagne is offline

average formal if cell contains number and text

Mac OS X

Office for Mac 2011

Novice

Join Date: Dec 2016

Posts: 1

Michael Labuschagne is on a distinguished road

average formal if cell contains number and text

A large quantity of data has been captured with units of measurement included in same cell as values. e.g. 65 kg or 1.2 metres

I have tried =AVERAGE(VALUE(LEFT(A13:A66,)))

But get a #VALUE error.

Please can someone explain how to property use the VALUE and LEFT functions or provide the correct formula.

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
looking to change cell color by typing number into the cell	ibs	Word Tables	1	11-22-2016 06:31 PM
Formula, Compare two cell's text and based on results output a number	Offrddrver	Excel	4	03-23-2016 11:32 PM
Data validation,force cell to be filed with number if respective cell is not empty	nicholes	Excel Programming	0	08-01-2015 09:08 AM
Entering a number in a cell causes it to fill with the color of a nearby cell	Bill Martz	Excel	1	04-23-2015 07:57 PM
Cannot Convert Text Cell to number format to be able to sort the data	jyfuller	Excel	10	06-19-2013 05:31 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:25 PM.