Split text

  • Thread starter Thread starter p.strijbosch
  • Start date Start date
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
 
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?
 
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
 
Back
Top