How does that stop you using the data in other formulae?
--
David Biddulph

"Makelei" wrote in message
...
Hi,
Thanks for you answer, but it does not help me (I know how to use that),
since I need to be able to use that data in other formulas...

Any proposals?

"OssieMac" wrote:

OK Makelei,

You should be able to do that with Text to Columns wizard. Look it up in
help and see how you go. Use the hyphen (-) as the delimiter.

"Makelei" wrote:

Hi,
The format of the column is as example:
"Ext- text2 that might have spaces - Text3 that have spaces"

I need to be able to get staright text: "Text2 that might have spaces"
and "Text3 that have spaces"

BR
MakeLei

"OssieMac" wrote:

Hi MakeLei,

Need some confirmation. Is there always a space, hyphen and space
between
each text string as you have written it.

Is it a column of data that you are trying to divide into separate
components? If it is then you can use Text to Columns Wizard and use
a space
as a delimiter (or if the hyphens exist then the hyphens as the
delimiters).
Lookup Text to columns wizard in Help.

If the above does not help then post a sample of the original data
and a
sample of how you want it to appear.

Regards,

OssieMac



"Makelei" wrote:

Hi,
I have in cell text as follows:
Text1 - Text2 - Text3

I need to get out Text2 in one cell and Text3 to another. What kinf
of
formula I could use? Lenght of Text2 and Text3 varies, Text1 is
always 3
characters.

Thanks in advance
MakeLei