Split text and numbers in Excel

Split text and numbers in Excel

The following formula is used to split text and numbers in Excel

Sarcs100 is the text under observation. The following will find the position of first character of the number.

Use mid function to get the text and numbers. The result is Sarcs and 100.

=MIN(FIND({0,1,2,3,4,5,6,7,8,9},A1&"0123456789"))

About the author: admin

You must be logged in to post a comment.