1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Solved: Excel 97: How can I convert "Columns to Text..."?

Discussion in 'Business Applications' started by bobarens, Nov 1, 2009.

Thread Status:
Not open for further replies.
Advertisement
  1. bobarens

    bobarens Thread Starter

    Joined:
    Nov 1, 2009
    Messages:
    6
  2. Zack Barresse

    Zack Barresse

    Joined:
    Jul 25, 2004
    Messages:
    5,447
    Hi there Bob, welcome to the board!

    First things first, edit your post and remove your email address. I'd leave it as "bob DOT arens 37 AT gmail DOT com" or something like that. There are automated bots which troll forums looking for email addresses and that's a perfect way to get some spam mail headed your way.

    Can you please explain what it is you are trying to do? And not how you want to get it done. Providing us with as many details as you can about your data, how it is structured, and the end result you are looking for, will get you the best help possible here.
     
  3. bobarens

    bobarens Thread Starter

    Joined:
    Nov 1, 2009
    Messages:
    6
    I started with 'no columns' created by copying and pasting from a txt file. I then did a "Text to Columns..." conversion in order to be able to insert the added data you see in 'all columns'. Now, I want to keep all the data shown in 'all columns', but, I want it like 'no columns'. i.e. the data as strings not separated into columns. See attached 'no columns' and 'all columns' jpg of Excel examples.
     

    Attached Files:

  4. Zack Barresse

    Zack Barresse

    Joined:
    Jul 25, 2004
    Messages:
    5,447
    I'm not sure what 'no columns' or 'all columns' are, I don't see those in your picture attachments. It appears you did a Text to Columns delimited with a space and then did some minor manual manipulation on the data (I'm willing to bet it took you quite a while?). But I'm still unclear as to what it is you are trying to do. You have the data, so what do you want to do with it now? If you can upload what you have, then explian what it is you are trying to do, that would help.
     
  5. bobarens

    bobarens Thread Starter

    Joined:
    Nov 1, 2009
    Messages:
    6
    Look more closely at the jpgs. You'll notice in the 'no columns' jpg that the text is continuous and not separated into columns, thus 'no columns'. The column headings; A, B, C, etc are there, but, no columns under these column headings. In the 'all columns' jpg you'll notice that each word (set of contiguous characters) of the text is in a separate column, thus, 'all columns'.
     
  6. Noyb

    Noyb Trusted Advisor

    Joined:
    May 25, 2005
    Messages:
    19,742
    A Tab character defines a new Column.

    Using Word .. Replace all the Spaces with a Tab .. Then Paste into Excel.
    or Tabs with Spaces .... Is this what you're looking for ???
     
  7. bobarens

    bobarens Thread Starter

    Joined:
    Nov 1, 2009
    Messages:
    6
    No. Following your instructions, I copied the Excel sheet to Word and then copied the Word document back into Excel and I ended up with a picture in Excel with no columns. That is not what I want. I want text in Excel like shown in my 'no columns' example.
     
  8. Noyb

    Noyb Trusted Advisor

    Joined:
    May 25, 2005
    Messages:
    19,742
    Can you attach an Excel here ... that you want to convert from ??
     
  9. bobarens

    bobarens Thread Starter

    Joined:
    Nov 1, 2009
    Messages:
    6
    YES YES YES. Your suggestion worked after I first replaced all the tabs in the Word file with spaces and then pasted into Excel as 'text'.
    THANK YOU VERY MUCH.
     
  10. Zack Barresse

    Zack Barresse

    Joined:
    Jul 25, 2004
    Messages:
    5,447
    Glad you got it solved. :) Can you mark your thread as solved?
     
  11. Noyb

    Noyb Trusted Advisor

    Joined:
    May 25, 2005
    Messages:
    19,742
    I thought you missed the "TEXT" part ..
    And was confused what you wanted to convert from.

    Sometimes .. I have to Paste to a Text file .. Then Copy > Paste to Word.
    This will remove some formatting .. If it gets in your way.
     
  12. Zack Barresse

    Zack Barresse

    Joined:
    Jul 25, 2004
    Messages:
    5,447
    ASAP Utilities has some good tools for removing characters from ranges as well.
     
  13. bobarens

    bobarens Thread Starter

    Joined:
    Nov 1, 2009
    Messages:
    6
    My Excel 'convert from column to text' problem is solved. GREAT JOB. THANK YOU.
     
  14. Noyb

    Noyb Trusted Advisor

    Joined:
    May 25, 2005
    Messages:
    19,742
    Look at the top of this page ... There is a place where you can mark it Solved.
    Since this is your post .. Only you can solve it.

    I'm not an Excel expert .. But Glad I could help.
     
  15. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/873596