First Letter From Cell to Another Cell

[the blue fox] · Jan 17th 2006

Hey All

I have SURNAMES being entered into cells B7:B105 .. I am looking for code that will take the first letter entered and put it into cells C5:C107

So .. if B5=Johnson .. C5=J

Is this possible? Can anyone help?

**Krishnakumar** · Jan 17th 2006

Re: First letter from cell - put into another cell

=left(b5)

HTH

Biz · Jan 18th 2006

Re: First letter from cell - put into another cell

Quote from Krishnakumar

=left(b5)

HTH

You mean =left(b5,1)

**Andy Pope** · Jan 18th 2006

Re: First letter from cell - put into another cell

As blue fox only wanted the first character omitting the number of characters from the LEFT function is ok as the help says

Quote

If num_chars is omitted, it is assumed to be 1.

Lippa · Sep 3rd 2006

Re: First letter from cell - put into another cell

What would the VBA equivalent of this formula be?

***EDIT:Sorry, thought you couldn't use that syntax in VB. Whoops

Participate now!