Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Adding Columns......

  1. #1
    New Member
    Join Date
    May 2002
    Location
    Minneapolis, MN
    Posts
    9
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I'm trying to programmatically grab data from a string which is located in xlsheet.Range("A" & i) row by row. With Mid, Instr, and Right split up the line of data where be needed and insert Columns to divide the string. Any ideas?

    My original approach was to grab the first section of data from the string, insert a column (Shift:=xlToRight), then paste. Once I've grabbed all the data I would delete the last column holding the original string. Is there any easier way?

  2. #2
    Board Regular
    Join Date
    Apr 2002
    Posts
    85
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Try using:

    Data>Text to Columns

    This will split whatever is in the selected cell into its own cell in its own column.

  3. #3
    New Member
    Join Date
    May 2002
    Location
    Minneapolis, MN
    Posts
    9
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    The line of code is? :
    Data>Text to Columns




  4. #4
    Board Regular
    Join Date
    Apr 2002
    Posts
    85
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    No. Select the cell you wish to parse. Then go to the top of Excel and look for:
    "Data" then choose "Text to Columns" then follow the wizard that follows.

    You might want to record this if you are looking for the code.

  5. #5
    New Member
    Join Date
    May 2002
    Location
    Minneapolis, MN
    Posts
    9
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I hear ya...I'll see if that helps.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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