Question:

How can I delete the entire row if the cell I am referring to is blank? For Example if A20 is blank, then I want to delete row 20. Please let me know the formula I need to use.

Answer:

There are two ways which you can achieve the end result.  Where formulas can’t delete rows you need to use either Filter or using VBA

1.       Using Filter on blank rows and delete all visible rows

2.       Using VBA, code given below.

Sub RemoveBlankRows()
'Deletes the entire row within the selection
On Error Resume Next
Selection.EntireRow.SpecialCells(xlBlanks).EntireRow.Delete
On Error GoTo 0
End Sub

Question:

How can I check if the first character in the cell is a alphabet or a numeric?

Answer:

=ISNUMBER(LEFT(A1,1)*1)

Please check the link given below for syntax and examples

http://www.helpmeexcel.com/isnumber-function/

IsNumber is a function which is use to check whether a particular value in numeric or not. If the value is number then it returns true else false.

Syntax:

IsNumber(value)

where value represent the value that you want to validate.

Example:

IsNumber(10) Returns True

IsNumber(150) Returns True

IsNumber(“HelpMeExcel”) Returns False

IsNumber(LEFT(“2007Excel,1)*1) Return True

In the last example it check whether the first char of the values is numeric or not. Where to make it works correctly we need to cast the results return by *1.