Thank you!!! Is there a place with lists of all formulas as I find the help
search useless?

"Wksht" wrote:

=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