That's a slick solution, using the Data to Column Wizard.
I was looking for a function I could work cell by cell.
Perhaps a string function with the " EA " as the logical anchor.
FIND(" EA ",A10)

so
=MID(A10,(FIND(" EA ",A10)-6),7)
would get me the value (dollar amount) right before the " EA "

But you see, getting the values that way is tough. If you look at the
1st 3 line, the value after " EA " are 2, 1 & 3 digits long.



On Dec 24, 8:37*am, Ron Rosenfeld wrote:
On Mon, 24 Dec 2007 07:38:06 -0800 (PST), wutzke
wrote:

We have a text file with
04 TRANS10.0 Witem dataMEO 5 2 2 0 37.29 EA 74.57 1.3 55.5
04 TRANS10.5 Mitem dataMEO 10 0 0 0 37.77 EA 0.00 3.8 172.3
04 TRANS10.5 Witem dataMEO 12 3 3 0 37.77 EA 113.31 3.3 154.3
04 TRANS11.0 Mitem dataMEO 6 0 0 0 37.77 EA 0.00 3.8 174.6
04 TRANS11.0 Witem dataMEO 8 2 2 0 37.77 EA 75.54 6.0 254.7
04 TRANS11.5 Mitem dataMEO 2 2 2 0 41.74 EA 83.48 1.9 88.6
04 TRANS11.5 Witem dataMEO 4 1 1 0 37.77 EA 37.77 4.5 207.3
04 TRANS12.0 Mitem dataMEO 5 1 1 0 42.99 EA 42.99 6.4 274.8
04 TRANS12.0 Witem dataMEO 5 0 0 0 43.78 EA 0.00 7.6 345.7