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

  • Thread starter Thread starter vssimmons
  • Start date Start date
V

vssimmons

I'm trying to take the first name in a column and get a result of the first
letter only in a new column.
 
Hi
If you have the name in A1 in B1 enter

=Left(A1,1)
If this was helpful please say yes
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VLOOKUP returning #N/A result 2
Excel Concatenate with line breaks but ignore blank cells 3
TRIM IF CELL CONTAINS ONE WORD, ABBREVIATE IF IT CONTAINS MULTIPLE WORDS 1
change array to simple columns 7
Formula result disappeared 5
split cell value 3
Counting and deleting 7
Using a sub string in a COUNTIF 2

Back
Top