View original (French)

Excel : replace TAB with RC

Solved
polo -  
Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   -
Hello,

I have a sequence of about fifty values separated by TAB.
I would like to convert this string in Excel so that each value is on its own line.
In other words, replace the TABs with new lines.

How can I do this, please?

Thank you.

10 answers

  1.
    ccm81 Posted messages 11033 Status Member 2 434
     
    re

    @lentz. actually, it seems that polo has a text file

    so
    in Excel
    open it as a text file
    then choose delimited
    then tab
    which should give you a file where the headers are in line
    if you want them in a column, you can use the transpose function
    and save it in Excel format

    PS. clearly stating the problem can help solve it ....

    good continuation
    1
  2. Lentz
     
    Can you send your file via cjoint.com as it allows for better understanding!
    0
  3. polo
     
    Thank you for your response... but there is nothing complicated about my statement.

    A string made up of x values separated by a tab.
    We want to convert this line (string) into a column with 1 line per value.
    0
    1. Lentz
       
      Maybe you understand since you have the file in front of you, but we have nothing... just your statement and what are RCs for you?
      0
  4. polo
     
    Sorry...
    RC = carriage return, that is, RETURN.
    0
    1. Lentz
       
      Are you on 2003 or 2007?
      0
  7. ccm81 Posted messages 11033 Status Member 2 434
     
    Hello
    the ASCII code for the horizontal tab is 9, and the carriage return is 13
    but, as Lentz said
    if you could send us a file (Excel 2003 format) with a cell containing a string of the described type, we would certainly see more clearly

    wishing you well
    0
  8. polo
     
    Je ne peux pas accéder à des liens externes ou des documents. Veuillez copier et coller le texte que vous souhaitez traduire ici.
    0
    1. Lentz
       
      You really don’t want us to help you

      ccm81 says: "if you could send us a file (Excel 2003 format)"

      You send: "http://www.cijoint.fr/cjlink.php?file=cj201110/cij2vaIDyd.txt"
      0
  9. polo
     
    http://www.cijoint.fr/cjlink.php?file=cj201110/cijBmm5oyT.xls

    Here...
    I thought it would be simple to copy and paste!
    Thank you for your help.
    0
  10. polo
     
    Note to the Tarnais: I honestly thought my problem was clearly stated!

    "A string composed of x values separated by a tab.
    We want to convert this line (string) into a column with 1 line per value."

    Thank you. See you soon.
    0
    1. Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   6 453
       
      Hello,
      it seems to you, but talking about TAB and RC is more complex than talking about rows and columns.


      Not much in your model, just a suspicion of wanting to switch from rows to columns, which remains to be demonstrated.
      Three options in the attached file,
      http://www.cijoint.fr/cjlink.php?file=cj201110/cijOFfhDxF.xls

      then come back to us to clearly (I insist) say what you want.
      Regards.
      0
  11. ccm81 Posted messages 11033 Status Member 2 434
     
    re

    well, if it's over, can you mark the issue as resolved

    have a great rest of the day
    0