Thread
:
Using the LEFT formula for multiple cells
View Single Post
#
4
Posted to microsoft.public.excel.worksheet.functions
Roger Govier
external usenet poster
Posts: 2,886
Using the LEFT formula for multiple cells
Hi Emily
LEFT(A1)&LEFT(B1)&LEFT(C1)
Without specifying the number of characters, the default is 1
--
Regards
Roger Govier
"Emily G" <Emily
wrote in message
...
I'm going nuts trying to figure out if I have mulitple cells, and I
want to
take the first character of each text string in each cell into one
cell what
do I use with the LEFT formula?
Example.
A1 = Hi
B1 = Ouch
C1 = What
D=HOW or =LEFT(A1,1),(B1,1),(C1,1)
Nothing I'm trying is working :(
Your help is appreciated!
Reply With Quote
Roger Govier
View Public Profile
Find all posts by Roger Govier