average formal if cell contains number and text

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

FAQ

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 »

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:18 AM.