combine formula

I now want to combine these two formulas. The concept is 100 data sets that I want to calculate values in 5 groups, and I also have 3 columns worth of data that need calculating. So assume the following: Cell D4 is where my criteria value will sit Cells D6-10 hold my ranges E5, E6 and E7...

I would like to combine: =Right(A1,LEN(A1)-FIND("-",A1)) and =LEFT(A1,LEN(A1)-4) To Result in: WINTER PARK From:ORLANDO RV-WINTER PARK, FL I need to drag down the formula to work with multiple locations, thus the FIND "-" Many Thanks!

I'm learning as I go with Excel, and can't get my head around how to write this formula (if it is even possible). I want to count the characters in a cell, but exclude certain characters (plural). E.g. coding and spaces. I know how to count the characters and exclude only spaces...

Here are my three formulas: in R6: =IF(K6="","",CHOOSE(MONTH(K6),2,2,2,3,3,3,4,4,4,1,1,1)) in Q6: =IF(K6="","",YEAR(K6)+IF(MONTH(K6)>=10,1,0)) in P6: =IF(Q6="","",("Q"&R6&" "&"FY"&Q6)) R6 finds the Fiscal Quarter of the date in K6 Q6 finds the Fiscal Year of K6 P6 combines the two results...

can someone advise how I can amalgamate the two formulas into one? =IF(ISNUMBER(MATCH(sheet1!R6,sheet2!$L:$L,0)),INDEX(sheet2!$J:$J,MATCH(sheet1!R6,sheet2!$L:$L,0)),"NOT DONE") =IF(E6="SHIPPER",INDEX(Client!$C:$C,MATCH(sheet1!C6,sheet3!$A$2:$A$10000)))