If formular (2 ifs) works alone, but not together

		Microsoft Office Forums > Microsoft Excel > Excel
If formular (2 ifs) works alone, but not together

FAQ

Thread Tools

Display Modes

Today, 09:54 AM

p45cal

Windows 10 If formular (2 ifs) works alone, but not together

Office 2021

Expert

Join Date: Apr 2014

Posts: 959

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

MSOfficeForums_Test1.xlsx (12.4 KB, 0 views)

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Merge documents;Formular with Checkboxes	Rekun	Word VBA	0	07-11-2018 11:51 AM
Date Range Formular	Colin C	Excel	5	04-22-2017 11:46 PM
Side view: Color of summary with formular interrupted	Mojo99	Project	5	10-07-2016 09:11 AM
I need to change a formular to overide formula	shanni11	Excel	1	09-10-2016 12:09 AM
Quick eplanation of formular	msheyworth	Excel	2	03-23-2013 11:43 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:19 PM.