Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Exrtacting text from a string
I need to extract stock symbols from a web query into their own cells.
Here are some examples of the raw data that is imported: ACAS|AMERICAN CAP, STRATETIES LTD|Q|Y|N| CT|Capital Trust, Inc.|NYSE|Y|| ENY|Claymore/SWM Canadian Energy Income Index ETF|Amex|Y|| I just need the ticker. This would be the first one to five characters in the string. The string is always delineated by the "|" symbol. I would love to do it using functions (I am not that handy with VBA). Thanks Dan |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Exrtacting text from a string
Try:
=LEFT(A1,FIND("|",A1)-1) -- Gary''s Student - gsnu2007h " wrote: I need to extract stock symbols from a web query into their own cells. Here are some examples of the raw data that is imported: ACAS|AMERICAN CAP, STRATETIES LTD|Q|Y|N| CT|Capital Trust, Inc.|NYSE|Y|| ENY|Claymore/SWM Canadian Energy Income Index ETF|Amex|Y|| I just need the ticker. This would be the first one to five characters in the string. The string is always delineated by the "|" symbol. I would love to do it using functions (I am not that handy with VBA). Thanks Dan |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Exrtacting text from a string
Alright, try selecting the data then going to
Data--Text-to-Colums Select Delimited Then uncheck Tab Check Other And type in | Then press finish " wrote: I need to extract stock symbols from a web query into their own cells. Here are some examples of the raw data that is imported: ACAS|AMERICAN CAP, STRATETIES LTD|Q|Y|N| CT|Capital Trust, Inc.|NYSE|Y|| ENY|Claymore/SWM Canadian Energy Income Index ETF|Amex|Y|| I just need the ticker. This would be the first one to five characters in the string. The string is always delineated by the "|" symbol. I would love to do it using functions (I am not that handy with VBA). Thanks Dan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change 3 letter text string to a number string | Excel Discussion (Misc queries) | |||
Sumif text is contained winthin a longer text string in a cell | Excel Worksheet Functions | |||
Splitting a text string into string and number | Excel Discussion (Misc queries) | |||
want to remove all text characters equal to one character in length from text string | Excel Worksheet Functions | |||
want to remove all text characters equal to one character in length from text string | Excel Worksheet Functions |