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.