How to extract text strings out of longer text string

**GIS2013** · 09-17-2013, 05:16 AM

Hi there. I've got a cell which contains this:

Please Login or Register  to view this content.

It's rather long, its total length is 315 characters.
I need to extract each of the 30 countries included in this single cell, without being so lengthy it's a no brainer..
Any ideas how?
Thanks

**sathiyamoorthy** · 09-17-2013, 05:27 AM

hi,

select the column of the cell and go to the data tap and find the option text to column and click.

click next and selct the delimiter comma (,) and click next and finish

you will get alll the location names in seperate cells in a row.

if you want all the data in column.
select the all the cell in that row and copy and go to the paste special option and select the transpose and click ok.

regards,
sathya

**GIS2013** · 09-17-2013, 05:51 AM

Thanks. Unfortunately it doesn't work. Here is the full list, I need each country to be in a different row..

Please Login or Register  to view this content.

**XOR LX** · 09-17-2013, 05:54 AM

Then simply do a Paste Special/Transpose on the output after applying the Text to Columns method outlined by sathiyamoorthy, which was mentioned in their post as well if you read it carefully.

Regards

**sathiyamoorthy** · 09-17-2013, 05:56 AM

it should work.

telll me where you are stuck exactly...

**GIS2013** · 09-17-2013, 05:59 AM

Could you show me please?, here is the file

**GIS2013** · 09-17-2013, 06:04 AM

**Update - I see, I should have created a lot of break lines, right? If so, is it the most efficient way?

**sathiyamoorthy** · 09-17-2013, 06:06 AM

hi,

please see the attachment... you may left the selection in the delimited option in the text to column wizard..

please click the star simple, if you satisfied with the reply.

**XOR LX** · 09-17-2013, 06:06 AM

You need to choose the Delimited option when you go into Text to Columns.

Regards

**GIS2013** · 09-17-2013, 06:08 AM

Thanks for everything guys, really.

How to extract text strings out of longer text string

LinkBack

Thread Tools

Rate This Thread

Display

How to extract text strings out of longer text string

Re: How to extract text strings out of longer text string

Re: How to extract text strings out of longer text string

Re: How to extract text strings out of longer text string

Re: How to extract text strings out of longer text string

Re: How to extract text strings out of longer text string

Re: How to extract text strings out of longer text string

Re: How to extract text strings out of longer text string

Re: How to extract text strings out of longer text string

Re: How to extract text strings out of longer text string

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Extract strings from a longer text string

Finding variable length text strings within a larger text string

Extract all text strings after a specific text string

Pass text strings longer than 255 characters

Vlookup name within longer text strings

Bookmarks

Bookmarks

Posting Permissions