show first few letters of a column in another cell

  • Thread starter Thread starter Glenn
  • Start date Start date
G

Glenn

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.
 
Back
Top