How do you trim a word like Nancy to 'N'
 

I'm trying to take the first name in a column and get a result of the first
letter only in a new column.

How do you trim a word like Nancy to 'N'
 

Hi
If you have the name in A1 in B1 enter

=Left(A1,1)
If this was helpful please say yes

"vssimmons" wrote:

I'm trying to take the first name in a column and get a result of the first
letter only in a new column.

How do you trim a word like Nancy to 'N'
 

if you want the first letter, try this in B2
=LEFT(A2,1)
--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another



"vssimmons" wrote:

I'm trying to take the first name in a column and get a result of the first
letter only in a new column.