+ Reply to Thread
Results 1 to 5 of 5

Please Help. Copied and pasted list that was not from excel. How do I separate words

  1. #1
    Registered User
    Join Date
    04-25-2013
    Location
    Southern New Jersey
    MS-Off Ver
    Excel 2007
    Posts
    1

    Please Help. Copied and pasted list that was not from excel. How do I separate words

    copied something like:

    ababbbb neihfhfhf hfhfhfhfh hfjkkdkdhd
    errfefcds ergetrga ergfarav awrefvwer
    woiejrgoo oeairgjoe aergergr aregarwge

    I want to separate this into 12 boxes. Is there a way to do that? I looked for the answer which may have already been answered, but can not find it. When I double click the A column it expands to include everything. I have included a screen shot, hopefully I have attached it properly. My email address is killingtimeemail@yahoo.com. I am a newbie at most of this (including the forums). It took me 20 minutes to make a thread. For some reason this section to be able to type a message was never showing up. The above part of it did. like the font, size, spellcheck, and options to include attachments. There was just no empty white box to type in. After numerous tries it just appeared. Go figure. Anyone who can answer the excel question will be my hero!! Thank you!!excel.jpeg

  2. #2
    Valued Forum Contributor Lemice's Avatar
    Join Date
    04-13-2013
    Location
    Somewhere.
    MS-Off Ver
    Excel 2016
    Posts
    696

    Re: Please Help. Copied and pasted list that was not from excel. How do I separate words

    Hello,

    First, I suggest you change your thread title so that others who might run into the same problem like you can find this thread easier using the Search tool.

    Second, you might want to try the function Text to Column in Excel.
    - Select all rows (In your ... picture, it's A1 to A11)
    - Click on "Data" on the menu bar, then choose "Text to Columns", choose "Delimited", "Space", and it will automatically do the job for you.

    Hope this help.
    (copy pasta from Ford)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools

    Regards,
    Lem

  3. #3
    Forum Contributor
    Join Date
    12-11-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    232

    Re: Please Help. Copied and pasted list that was not from excel. How do I separate words

    Lemice beat me to it.

  4. #4
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,860

    Re: Please Help. Copied and pasted list that was not from excel. How do I separate words

    Hi and welcome to the forum,

    Find the attached with this really cool formula
    =TRIM(MID(SUBSTITUTE($A1," ",REPT(" ",LEN($A1))),(COLUMN()-2)*LEN($A1)+1,LEN($A1)))

    Put it in A2 and pull across and down for your answer.
    Attached Files Attached Files
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  5. #5
    Forum Expert
    Join Date
    10-10-2008
    Location
    Northeast Pennsylvania, USA
    MS-Off Ver
    Excel 2007
    Posts
    2,387

    Re: Please Help. Copied and pasted list that was not from excel. How do I separate words

    killingtimeemail,

    Welcome to the Excel Forum.

    With your raw data in column A, beginning in cell A1. The data will be split into cells in column A.

    Please TEST this FIRST in a COPY of your workbook (always make a backup copy before trying new code, you never know what you might lose).

    1. Copy the below code, by highlighting the code and pressing the keys CTRL + C
    2. Open your workbook
    3. Press the keys ALT + F11 to open the Visual Basic Editor
    4. Press the keys ALT + I to activate the Insert menu
    5. Press M to insert a Standard Module
    6. Where the cursor is flashing, paste the code by pressing the keys CTRL + V
    7. Press the keys ALT + Q to exit the Editor, and return to Excel
    8. To run the macro from Excel, open the workbook, and press ALT + F8 to display the Run Macro Dialog. Double Click the macro's name to Run it.

    Please Login or Register  to view this content.
    Before you use the macro with Excel 2007 or newer, save your workbook, Save As, a macro enabled workbook with the file extension .xlsm

    Then run the ReorgData macro.
    Last edited by stanleydgromjr; 04-25-2013 at 03:08 PM.
    Have a great day,
    Stan

    Windows 10, Excel 2007, on a PC.

    If you are satisfied with the solution(s) provided, please mark your thread as Solved by clicking EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1