Prev: VBA Copy values only onto new workbook
Next: Conditional formatting dates
From: lbps on 4 May 2010 21:10
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

--
lbps
From: trip_to_tokyo on 4 May 2010 23:06
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.





"lbps" wrote:

> 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
>
> --
> lbps
From: ozgrid.com on 4 May 2010 23:13
=LEFT(A1) and copy paste special values.



--
Regards
Dave Hawley
www.ozgrid.com
"lbps" <lbps(a)discussions.microsoft.com> wrote in message
news:00FD70E3-DFB3-4E23-8003-2B823A383D65(a)microsoft.com...
>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
>
> --
> lbps

 | 
Pages: 1
Prev: VBA Copy values only onto new workbook
Next: Conditional formatting dates