+ Reply to Thread
Results 1 to 2 of 2

Extracting text from a group of cells

  1. #1
    Registered User
    Join Date

    Extracting text from a group of cells

    Ok, here's the deal: I have a bunch of data in a .txt format and I paste it into Excel. Excel separates the data into rows and columns but the data isn't always the same so it doesn't get put in the same format every time. All I know is that in some cell there will be the text "/country="random country"". I need to search through all the cells for the "/country" tag and then take whatever country happens to be specified.

    I was able to do this if I pasted all my data into one cell because I just used the function 'Find("/country",G24)' and it told me the character location of "/country" in cell G24, but sometimes there is so much data that I can't put it all in one cell.

    Hopefully someone can give me an idea of how to do this, thanks.

  2. #2
    Forum Contributor
    Join Date
    import your text into excel using the import text wizard

    open excel, choose open, then find your txt file and it'll start it automatically

    your data is probably either comma delimited or tab delimited.
    this doesn't exactly answer your specific question but I think it'll allow you to view your data in such a way that your problem will be non-existant.

    it'll solve other problems you'll eventually encounter

+ Reply to Thread

Thread Information

Users Browsing this Thread

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


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