Hey, so I have a formula "=+'All Records-Department Specif'!H2".... which works fine to return data from the All Records-Department Specif sheet and place it into my second sheet.
My question is how do I get only the first number of the H2 cell?
I have tried every combination I can think of"=+'All Records-Department Specif'!(Left(H2))"
THoughts?
My question is how do I get only the first number of the H2 cell?
I have tried every combination I can think of"=+'All Records-Department Specif'!(Left(H2))"
THoughts?