Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 11-18-2015, 01:44 PM
Learner7 Learner7 is offline How to write a formula to simplify the work? Windows XP How to write a formula to simplify the work? Office 2007
Advanced Beginner
How to write a formula to simplify the work?
 
Join Date: May 2010
Posts: 51
Learner7 is on a distinguished road
Default How to write a formula to simplify the work?

The following is the example data:



TA-151700001.06
SER

TA-151700001.07
SER

TA-151700001.08
MP
SER

TA-151700002.06
SER

TA-151700002.08
MP
SER

TA-151700001.01.01
SER

TA-151700001.02.01
MP
SER

And this is the result I need:

TA-151700001.06 SER

TA-151700001.07 SER

TA-151700001.08 MP
TA-151700001.08 SER

TA-151700002.06 SER

TA-151700002.08 MP
TA-151700002.08 SER

TA-151700001.01.01 SER

TA-151700001.02.01 MP
TA-151700001.02.01 SER

What I need is, the data below TA-15170000* which is "MP" OR "SER" or both should be like the above.

Please help.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
formula does not work properly msnarayanan Excel 2 08-12-2015 12:40 AM
How to write a formula to simplify the work? Is there a shorter way to write this formula? babs1234 Excel 1 03-09-2015 12:16 AM
How to write a formula to simplify the work? Excel simplify formula - array of sequential numbers Wries Excel Programming 1 05-12-2014 08:32 AM
write need help and copy write need help on another page auto wykoems Word 2 07-25-2013 07:56 AM
How to write a formula to simplify the work? How can I write the following (whole) formula in a single cell? Learner7 Excel 1 07-19-2010 10:06 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:48 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft