Formula

[Guest]

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

 

[Guest]

=LEFT(cell reference,4)

 

[Guest]

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

 

[David Biddulph]

A list of all formulae would be infinitely long.

If you mean a list of functions, does
http://office.microsoft.com/en-us/excel/CH062528191033.aspx or
http://office.microsoft.com/en-us/excel/HP052042111033.aspx help you?
Just remember to add DATEDIF to the list.