Hi All,
Been Struggling to work out but basicall I have the following Cell text and want to do the following:
Nti09:14/id1/OP/ARgemeen Disarm Level A
Nti16:13/id1/CL/AAlgemeen Armed Level A
Nti02:01/RP/APeriodic Test
Now unless the Cell contains AP for example I want to trim and leave the following Text, I can get this to work on one Find, but there are multiple condition and tried adding an OR function with no success:
Output:
Nti09:14/id1/OP
Nti16:13/id1/CL
Nti02:01/RP/APeriodic Test
=IF(OR(FIND("/AA",$H259,1),(FIND("/AN",$H259,1)),(FIND("/AR",$H259,1)),(FIND("/AS",$H259,1)),(FIND("/AT",$H259,1))),$H259,
TRIM(LEFT(SUBSTITUTE($H259,"/A",REPT(" ",100)),100)))
Individual that works is as followed, but if this doesn't find AR I get a #Value! error.
=IF(FIND("/AP",$H258,1),$H258,
(TRIM(LEFT(SUBSTITUTE($H258,"/A",REPT(" ",100)),100))))
Any help is much appriciated
Bookmarks