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

 

Please confirm:

1) The numeric part is always at the end of the text
2) The numeric part never has any spaces in it.

Also, do you want the numeric part separated as a number or as a string
value?

Regards, Dave S

----- Original Message -----
From: "Barry White" <imtigerwords@yahoo.com>
To: <ExcelVBA@yahoogroups.com>
Sent: Tuesday, November 01, 2011 5:51 AM
Subject: [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]

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

----------------------------------
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

----------------------------------Yahoo! Groups Links

-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 10.0.1411 / Virus Database: 1522/3985 - Release Date: 10/30/11

__._,_.___

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

Messages in this topic (6)

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

.

__,_._,___