On Tue, 04 May 2010 08:08:12 GMT, "mark_jm via OfficeKB.com" <u19922@uwe
wrote:

Ron Rosenfeld wrote:
I have exported some stuff from an outlook inbox into excel for analysis.
The boby of the emails I have exported contain data which I need, each piece
[quoted text clipped - 20 lines]

Mark

One way.

A1: Your import
A2: =MID($A$1,ROWS($1:1),1)
B2: =CODE(A2)

Select A2:B2 and fill down at least LEN(A1) rows.
--ron


Thansk for your insight sonnds promising, but your suggestion returned
coulmn a and b as fllows( just and extract here )

C 67
D 68
C 67
o 111
n 110
t 116
r 114
o 111
l 108
s 115
46
i 105
A 65
D 68
"
" 13
"
" 10
S 83
T 84


how does this help?

Mark

Your delimeter is the <Carriage Return<Line Feed sequence <CR<LF
represented in the above as the 13 10 sequence. I suspect if you examine
closely you will see that sequence at each line break. And that in Excel, the
symbol will be different than the quote mark showing above, and that there will
not be a blank row preceding each 13 and each 10.

There are a number of ways to handle this, depending in part on whether this
will be a one time analysis, or done multiple times.

Manually:

1. Remove one of the delimiters.

A1: Your Data
B1: =SUBSTITUTE(A1,CHAR(13),"")
Select B1
Edit/Copy
Select C1
Edit/Paste Special/Values

2. Use the Text to Columns wizard to split into columns.

Select C1
Data/Text-to-columns
Step 1:
Delimited
<Next
Step 2:
Clear all boxes
Text qualifier: set to {none}
Select Other
with cursor in the box next to other, while holding down the
<alt key, type 010 on the **Numeric Keypad** (not on the number keys above the
regular keyboard). Then release the <alt key

<Next

Step 3:
Format (or skip) columns if necessary
<Finish

If this is going to be a repeated task, I would use a VBA macro, but for just
once or twice, the above is probably simplest and quickest.

--ron