Question

how can you sort text and number?illustrate with the help of suitable example.​

Answer 1

$\huge\boxed{\fcolorbox{black}{pink}{Hello\: Mate}}$

Select a blank cell beside the numbers with letter prefix or suffix, says Cell B2, type the formula =EXTRACTNUMBERS(A2,TRUE) (A2 is the cell of number with letter prefix or suffix) into it, and then drag this cell's AutoFill Handle to the range as you need.

$\huge\mathbf{\overbrace{\blue{Hope\: It \: Helps}}}$

Answer 2

Answer:

Select a blank cell beside the numbers with letter prefix or suffix, says Cell B2, type the formula =EXTRACTNUMBERS(A2,TRUE) (A2 is the cell of number with letter prefix or suffix) into it, and then drag this cell's AutoFill Handle to the range as you need