Array Range Depends on Value in Each Cell-input an array

I am trying to input an array that differs in size depending on value/type of each cell. For example I have the following scenario:


______Column A
Row1 _____1
Row2_____cat
Row3_____dog
Row4______1

In this example I want the array to only include the rows in Column A that have text, not numbers (i.e. A2:A3). However, the value/type in each cell can change (e.g. A1 could become a text), in which case I need the array range to change (e.g. range would change to A1:A3). Basically I want to loop through the column and only return a range of text only. I have very basic skill in VBA and was hoping I could do this with excel's formulas. Any ideas of how I can do this?

Hi and welcome to the forum
Actully it can be done with an array formulae. But it is not clear what the result look like....
Do you want do return address of text entries like A2 and A3 ????