How to get numbers and text from data cell in excel using vba July 02, 2020 u face many problem to seperate the number from text in excel here is simple way to create a formula to get result by just copy & paste 1) click alt+f11 2 )insert module 3) copy it Read more