Hi,
I am trying to make a simple formula to calculate values in an array of cells. The cells contain text and numbers, text or can be blank. I am not an excel professional...
Data sample:
Cell Cell-content
B2 Mr. Hansen Dlx Dbl /55
B3 Mr. Olsen Sup Sgl /45
B4 Mrs. Simpson Std Sgl /40
B5 Robert...