 | Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years. Thanks, CNET Support |
hi there,
is there any way that i can have a cell only say the left-most letter like:
=FUNCTION???(refers to cell)
it would say something like:
"A" if the referenced cell said "Avacado"
"T" if the referenced cell said "Tractor"
thanks very much in advance for your time
Kirkey
Discussion is locked
If you only want the first character in any word, try this;
=LEFT(A1,1)
Where A1 is the cell where your word has been input.
So, for example, if A1 holds Avacado, then input this formula into cell B1 =LEFT(A1,1)
And B1 will then display A
Does that help?
Mark
Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic