Results 1 to 5 of 5

Data Repeating Characters into Muliple Columns

Threaded View

stva1006 Data Repeating Characters... 11-30-2012, 05:24 PM
djapigo Re: Data Repeating Characters... 11-30-2012, 05:36 PM
stva1006 Re: Data Repeating Characters... 11-30-2012, 05:40 PM
djapigo Re: Data Repeating Characters... 11-30-2012, 06:10 PM
stva1006 Re: Data Repeating Characters... 11-30-2012, 06:30 PM
  1. #1
    Registered User
    Join Date
    11-30-2012
    Location
    AUstin, Texas
    MS-Off Ver
    Excel 07
    Posts
    5

    Data Repeating Characters into Muliple Columns

    I have tens of thousands of rows of data that come in like the following:
    This+is+a+test
    The problem is I have to break this down and put it all together in multiple ways. Everything before the first Plus needs to remain intact and keep the +, but all remaining pluses need to be changed to "-". Then I need to have everything in between the "-" broken into columns of which those individual elements need to be edited using another list using vlookup, edited and then concentated back into one column with the delimiters.

    Its a little more complicated because some have multiple +'s, some have just one and some have +'s and -'s. I have attached a sample. I've made some progress but need everything from column E and on sorted so I can do the vlookup on them.

    Oh and everything using vlookup needs to be changed to something else. Some are already correct and output to the same thing.

    Sample.xlsx
    Last edited by stva1006; 11-30-2012 at 05:30 PM.

Thread Information

Users Browsing this Thread

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

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