Formula
=LEFT(cell reference,4)
"Shannon" wrote:
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
|