Thread
:
enter 5 in 1 cell, show first 3 in other cell
View Single Post
#
5
Posted to microsoft.public.excel.misc
David Biddulph
Posts: n/a
enter 5 in 1 cell, show first 3 in other cell
"JcR" wrote in message
...
I want to be able to:
enter a 5 digit number into in cell a1
have the first 3 digits appear in cell a2
=LEFT(A1,3)
--
David Biddulph
Reply With Quote
enter 5 in 1 cell, show first 3 in other cell