Formula Modify

[Rubber Beaked Woodpecker]

In D84 I have the following formula;

=IF(AND((100-$A83)>=D$141),"",IFERROR(INDEX(29:29,AGGREGATE(14,6,COLUMN($D70:$XFD70)/($D70:$XFD70<>""),COLUMNS($D$2:D$13))),""))

It normally returns data in the following format;

Aisle1 4th Mar - 14:10 Middle Left

Is there a way to modify the original formula so only the following is returned?

4th Mar - 14:10

Many thanks,

RBW

 

[awoohaw]

Can you use the xl2bb add in and post a mini worksheet of your data? Link is below.
But try:
=Mid(D84, Find(" ",D84)+2), 17)
that will work assuming you have the day as only 3 digits, the hour has leading zeros.

 

[Snakehips]

@Rubber Beaked Woodpecker
If you have consistency of day, date, time format then maybe focus on the "-" similar to the below.
You can substitute the D84 cell reference with your original formula.

Book2
	D	E
84	Aisle1 4th Mar - 14:10 Middle Left	4th Mar - 14:10
85	Aisle6 1st Mar - 14:10 Middle Right	1st Mar - 14:10
86	Aisle 99 14th Jun - 15:15 Center	14th Jun - 15:15
Sheet3

Cell Formulas
Range	Formula
E84:E86	E84	=TRIM(MID(D84,FIND("-",D84)-9,17))

Hope that helps.

 

[fjns]

Hi, try this formula
=MID(D84,SEARCH(" ",D84)+1,SEARCH(":",D84)-SEARCH(" ",D84)+2)

 

[Rubber Beaked Woodpecker]

Perfect thank you