First Letter From Cell to Another Cell

  • 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?

    Tayler [the blue fox] :thanx:

  • Re: First letter from cell - put into another cell


    Quote from Krishnakumar

    =left(b5)


    HTH


    You mean =left(b5,1)

  • 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.

    [h4]Cheers
    Andy
    [/h4]

  • 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!

Don’t have an account yet? Register yourself now and be a part of our community!