Converting in array

[Salman98]

Is there a formula or any complex formula to change this array from {“4”;”1”;”G”;”9”;”H”} to
{4;1;”G”;9;”H”}, keeping alphabets stored as text and changing numbers from text to number formatting

 

[Fluff]

Duplicate Convert a number stored as text to number
Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).