 |
 | 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 / Worksheet Functions / August 2006If Question
How do I put this into an excel formula ? If this "MID(N3;6;3)" equals "OLA" then do this "MID(N3;6;3)&LEFT(N3;3)" otherwise Y3&MID(N3;6;3) Thank you in advance. Can't really check this without knowing what your data looks like but see if this works. =IF(MID(N3,6,3)="OLA",MID(N3,6,3)&LEFT(N3,3),Y3&MID(N3,6,3)) > How do I put this into an excel formula ? > [quoted text clipped - 5 lines] > > Thank you in advance. =IF(MID(N3;6;3)="OLA",MID(N3;6;3)&LEFT(N3;3),Y3&MID(N3;6;3)) > How do I put this into an excel formula ? > [quoted text clipped - 5 lines] > > Thank you in advance. |
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.