Thread: If formular (2 ifs) works alone, but not together
View Single Post
 
Old Today, 09:54 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2021
Expert
  
Join Date: Apr 2014
Posts: 959
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default
Take a look at column K in the attached:
Code:
=INDEX(TEXTSPLIT(TRIM(INDEX(TEXTSPLIT(E2,{"PK","PKR"}),2)),{" ","-"}),1)
It works for all of your sample data but do test it more thoroughly.


ps. You seem to be one (of many) people who only acknowledge past help when they need more help.
Attached Files
File Type: xlsx MSOfficeForums_Test1.xlsx (12.4 KB, 0 views)
Reply With Quote