» Find the value in the first non blank cell in range in Microsoft Excel

CATEGORY - Other Q&A Formulas VERSION - All Microsoft Excel Versions

Text/Numeric data in column A

A1 	 
A2  	AAA 
A3
A4	BBB
A5	CCC
A6	DDD
A7	502
A8	EEE
A9	
A10

Formula in cell B1: {=INDEX(A1:A10,MATCH(TRUE,LEN(A1:A10)<>0,0),1)}

Result:		    AAA

Please note:
The formula is an Array Formula, after entering the formula in the cell, press F2 and than press Ctrl+Shift+Enter Screenshot // Find the value in the first non blank cell in range in Microsoft Excel