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?
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?
Re: First letter from cell - put into another cell
=left(b5)
HTH
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
QuoteIf num_chars is omitted, it is assumed to be 1.
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
Don’t have an account yet? Register yourself now and be a part of our community!