Home |
Search |
Today's Posts |
#6
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Thanks Harlan .... I was sure mine could be improved!
"Harlan Grove" wrote: Toppers wrote... Assuming data in A1: in B1: =LEFT(A1,FIND("-",A1)-1) in C1: =IF(LEN(A1)-LEN(SUBSTITUTE(A1,"-",""))=2, MID(A1,LEN(B1)+2,FIND("-",A1,LEN(B1)+2)-(LEN(B1)+2)), RIGHT(A1,LEN(A1)-(LEN(B1)+1))) Could be shortened to =MID(A1,LEN(B1)+2,FIND("-",REPLACE(A1&"-",1,LEN(B1)+1,""))-1) in D1: =IF(LEN(A1)-LEN(SUBSTITUTE(A1,"-",""))=2, RIGHT(A1,LEN(A1)-(LEN(B1)+LEN(C1)+2)),"") Could be shortened to =MID(A1,LEN(B1)+LEN(C1)+3,LEN(A1)) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
What formula is used for subtracting a range of different cells f. | Excel Worksheet Functions | |||
quick way to copy-paste a formula linked to cells in another file | Excel Worksheet Functions | |||
Formula works in some cells, doesn't in other | New Users to Excel | |||
trying to create an (almost) circular formula between cells and data validated cells with lists | Excel Worksheet Functions | |||
Applying formula to only NON-EMPTY cells in range | Excel Discussion (Misc queries) |