Hi!

I am trying to reference a cell that contains data such as "ABCD - Text". I
would like to find a formula that would reference the cell but only take the
"ABCD" (the first 4 characters).

Any help would be wonderful!

Thanks!
Shannon