Microsoft Office Forums - View Single Post - perform multiple operations when condition fulfilled

Thread: perform multiple operations when condition fulfilled

View Single Post

Old

05-28-2020, 10:33 AM

albyefield albyefield is offline

albyefield is offline

albyefield uses Windows 10

Windows 10 albyefield uses Office 2016

albyefield uses Office 2016

Office 2016

Novice

The original poster

Join Date: Jul 2012

Location: Exeter

Posts: 27

albyefield is on a distinguished road

Default

Thank you problem now solved
here is the solution giving results in columns D & E

=IF(ISERROR(FIND("i",A2)),A2,LEFT(A2,FIND("i",A2)-1))

=IF(A2<>D2,RIGHT(A2,LEN(A2)-LEN(D2)),"")

Thanks for the hint

Reply With Quote