|
|
#1
11-18-2015, 01:44 PM
|
|||
|
|||
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. 
|
|
#2
11-19-2015, 12:46 AM
|
||||
|
||||
|
Please post a sample file - Thx
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| formula does not work properly | msnarayanan | Excel | 2 | 08-12-2015 12:40 AM |
 Is there a shorter way to write this formula?
|
babs1234 | Excel | 1 | 03-09-2015 12:16 AM |
|
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 can I write the following (whole) formula in a single cell?
|
Learner7 | Excel | 1 | 07-19-2010 10:06 AM |
Windows XP 
Office 2007
Linear Mode
