[ExcelVBA] Text to columns, alpha characters first then numeric

 

Howdy all,
 
I have example data below,
 
DIFF WKND PCT A 1090.52
REG 13621.58
 
I want the above data split into 2 columns and only ever two columns.
 
1. All the text or alpha characters in one column
 
2. All the numeric characters in another column
 
The result should be below:
 
DIFF WKND PCT A 1090.52
REG  13621.58

How do I do this?  Text to columns by the "delimited space" method winds up that the first row contains 5 columns and the second row contains two, and the numeric portion is slotted in different columns because of it.
Eric Lutz
 
.

[Non-text portions of this message have been removed]

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (8)

Recent Activity:

• New Members 4

Visit Your Group

----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------

MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___