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

• Create User Forms in Microsoft Excel
• Using Loops in VBA in Microsoft Excel
• The Best Shortcut Keys in Microsoft Excel
• Writing Your First VBA Function in Excel
• Add Combo Box to a Sheet in Microsoft Excel
• Formulas to calculate Loan payments in Microsoft Excel
• Array variables using VBA in Microsoft Excel
• Create an Amortization Schedule in Microsoft Excel
• Find duplicates items in combine columns in Microsoft Excel
• Vlookup Formula – Organizing the Data Table