Try:

=CODE(MID(<cell Reference with the text,62,1))
(or whatever it is in German)
it should return 109, the code for the letter "m" the last letter in the
first row of text.

Now try

=CODE(MID(<cell Reference with the text,63,1))

which should return the next character after the "m"


--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"Andrewsan" wrote in message
...
A file with multiple columns contains a long text string in col B ...
this text contains carriage returns that I want to get rid of:

ideal is to convert the text string in col B into several separate
columns.

here's the pain points:
* the excel version I'm using is 2003 (OK) but German language UI (Yuk)
* function "ersetzen / susbtitute" doesn't work
* the carriage return doesn't respond to suggestions from previous posts:
viz
char(10) / Chr(10) or char(13) / Chr(13)

Here's a sample of col B, where * represents the carriage return:

'A user has entered the following data in our subscription form:*
*
*
Name: firstname lastname*
*
Country: antarctica*
*
E-mail Address: *
*

- example ends.

and, no, sadly there is no DB to go back to, to do a re-export; this
spreadsheet is all there is (sigh).

all/any advice greatly appreciated