finding substring from the some column and updating another column based upon that

mayank.ahuja

New Member
Joined
Mar 16, 2009
Messages
1
Hi

I am a bit new to excel functions, so want some help.

I am writing down one of of the cell's value ( e.g; position D3) in my excel sheet. I have written the value like you can understand my problem.



The following code is present in work log column of the report extracted through Remedy.
And I want to find this particular code eTS1FNUAT. If its preant in this particular cell then ,
I want to write in the other column corresponding to it the relevant code, like for this
it would be Functional_Problem_Ticket.

There can be other value of the substring like eTS1DBUAT, which indicates this is Database_Problem_Ticket.

The first 3 character will always be eTS and 4th character can have value out of 1, 2, 3 .
5th, 6th character can have value out of FN, DB, AC .
rest last 3 character 7, 8, 9 can have value only UAT

But there will be only one code will be present in the cell, that is for sure.
like either eTS1FNUAT or eTS1DBUAT
In short I want to look for %eTS?FN% or %eTS?DB% , %eTS?AC% .


Code written the bold above is my D3 cells value and similar value is there in another row under the same column.
like in D4, D5, D6 , etc.


Or, in nutshell, I have to tell the "ticket type resolved" depaning upon this worklog column in my excel sheet, which contains ticket resolution code.
 
Last edited:

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

Forum statistics

Threads
1,224,269
Messages
6,177,566
Members
452,784
Latest member
talippo

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top