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.

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

"Glenn" <[email protected]> wrote in message
news:[email protected]...
>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.
>
>