 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / June 2005Split text
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?  SignatureHTH Bob Phillips > Hello, > [quoted text clipped - 13 lines] > Regards, > Robert 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 Robert, In that case, it is just simply =RIGHT(A1,LEN(A1)-27) SignatureHTH Bob Phillips > Hi Rob, > [quoted text clipped - 9 lines] > Regards, > Robert |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.