How to Separate Text From Numbers in Excel : Microsoft Excel Tips

Subscribe Now:

Watch More:

Separating text from numbers in Excel is something that you can easily do by copying and pasting in the appropriate way. Separate text from numbers in Excel with help from an expert with more than a decade of experience working with Microsoft Office and Adobe Creative Suite in a professional capacity in this free video clip.

Expert: Justin Conway
Filmmaker: Nick Laden

Series Description: Microsoft Office is a productivity suite with a wide variety of popular programs, like Microsoft Excel, Word and PowerPoint included at the time of purchase. Get Microsoft Excel tips with help from an expert with more than a decade of experience working with Microsoft Office and Adobe Creative Suite in a professional capacity in this free video series.

[ngb]

so how would you extract just the text?

[liorsinger]

Please copy and paste the formula to here.Thank you

[johnukos]

i get an error "value not available error"

[bonitabester]

It would be very useful if the formula could be explained....

[DarlitaDawn]

You know we can't really see the formula clear enough when it is video format. Have you just saying it us in the video otherwise its kind of not worth it.

[terrencepeeples]

Doesn't work. Looks great but is worthless.

[energyeternal]

this is somewhat close (i used abby).... why didnt he post the formula?? what a silly move.
{ = 1"MID(A2, MATCH(TRUE, ISNUMBER(1'MID(A2, ROW(S1:S39), 1)).0), COUNT(1'MID(A2, ROW(S1:S39), 1)))}

[energyeternal]

this is close:
{=1*MID(A2, MATCH(TRUE, ISNUMBER(1*MID(A2, ROW($1:$39), 1)), 0), COUNT(1*MID(A2, ROW($1:$39), 1)))}

[unixfly]

Worthless. He just talks but nothing is really said.