Results 1 to 5 of 5

Thread: How to separte the letters in an excel sheet by using formula

  1. #1

    How to separte the letters in an excel sheet by using formula



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Dear Friends,


    I would like to separate the first letter and rest of sentence in two different columns in an excel sheet by using the formula. I could separate the first letter by using the function =left (A1, 1), in another column which is B. But not able to apply the same logic for rest of sentence, as the same is containing number of letters. Hence kindly guide me here which formula needs to be applied for the same to exclude the first letter in column C.


    Attached an excel sheet for your ready reference.


    Thanks in advance,
    Attached Files Attached Files

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,437
    Articles
    0
    Excel Version
    Excel 2016
    Try:

    =TRIM(MID(A2,2,255))


  3. #3
    Super Moderator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,320
    Articles
    0
    Excel Version
    2010 on Xubuntu
    Alternatively - Data - Text to columns - fixed width - insert a line break after the first character - Done

  4. #4
    Thank you very much ..........

  5. #5
    Quote Originally Posted by NBVC View Post
    Try:

    =TRIM(MID(A2,2,255))
    Thanks a lot

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •