copying editing cells

  • Thread starter Thread starter lbps
  • Start date Start date
L

lbps

I have a colum with full names ie John but I only want the first initital -
is there anyway to cut and paste or whatever so I only get the first letter
from each name ??
So John becomes J and so on

thanks
 
EXCEL 2007

=LEFT(B7,1)

Change the B7 to the cell whose contents you wish to truncate.

Copy and paste as required.

If my comments have helped please hit Yes.

Thanks.
 
Back
Top