extract partial numeric or text value from within cell

B

buej

I have the following in 1 column:

67SMITH
9221POE
008888FISHRE
1TATE
33 MYER
8908456311LAR

I need to separate out the numbers from the text so that it looks like
this in 2 columns:

67 SMITH
9221 POE
008888 FISHRE
1 TATE
33 MYER
8908456311 LAR

Any ideas??
 
J

Jerry W. Lewis

You could strip off the digits with nested SUBSTITUTE() calls. This
would require a helper column, since Excel supports no more than 7
levels of function nesting. Once you have the text column, you could
strip the text portion out with a single SUBSTITUTE() call.

Jerry
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Finding the proper style field and the numbered paragraph value within the style 0
Grow/Shrink Text gradually from slide to slide 0
Extract Text in braquet and list of terms from 2 Docs 3
Extract numeric from text string 4
Macro lookup is not working good? 5
Function or Sub to help with text string 5
find and replace numeric strings in larger text strings 8

Top