show first few letters of a column in another cell

I know how to use left to show the first character of a particular column in
another column.

What I need to do is show the first seven characters.

For Instance:

Column A has a value of "McDonald"

I want Column B to show "McDonal"

Thanks.


0
nospam (155)
4/4/2005 5:50:53 PM
excel 39879 articles. 2 followers. Follow

1 Replies
396 Views

Similar Articles

[PageSpeed] 55

=LEFT(A1,7) if A1 is your reference cell.
-- 
HansM

"Glenn" <nospam@yahoo.com> wrote in message 
news:O1l1Z7TOFHA.1040@TK2MSFTNGP12.phx.gbl...
>I know how to use left to show the first character of a particular column 
>in
> another column.
>
> What I need to do is show the first seven characters.
>
> For Instance:
>
> Column A has a value of "McDonald"
>
> I want Column B to show "McDonal"
>
> Thanks.
>
> 


0
sayno2 (17)
4/4/2005 5:59:27 PM
Reply:

Similar Artilces: