Split text

P

p.strijbosch

Hello,

Can someone tell me how to cut out a part of a text?

Example:
A
1 Portfolio and Data at end: June 2004

The first part (Portfolio and Data at end: ) is fixed and so the only
part I would like to cut off is the date and year. But as the date
lenght differs, I'm not able to use the LEFT of RIGHT function. I tryed
=A1-LEFT(A1,27) but it does not work.

In advance thanx for your suggestions!

Regards,
Robert
 
B

Bob Phillips

Are there any rules for where a date would start, or its format. For
instance, is there always the word end, or is it always full month name, or
anything else?
 
P

p.strijbosch

Hi Rob,

The first part "Portfolio and Data at end: " is always the fixed, the
date is always in text format like February 2004, March 2004 etc.
Bottom line I only want to exclude the text "Portfolio and Data at end:
" (27 positions).

Jope that this answers your question.

Thanx for helping me out!

Regards,
Robert
 
Top