VBA code to split text and number from the string in Excel (Mid function)

###With the help of mid function in VBA to split text and number from the string in Excel or to check number or not## VBA code to get number and text from the string in Excel##
##vba code to use mid function in Excel##
##mid function in Excel VBA##
##isnumeric function in Excel VBA##
##multiple for loops in Excel VBA##
# for loop in Excel VBA##

[souvikdas]

Pls provide the code in description please

[sushilsharmahr]

Sir PlZ make video to split name in different column like( India ) = I N D I A IN DIFFERENT COLUMNS PLZZ SIR