Hello,
I can't figure out how to search for way to extract data from a text string and move the extract data to a new column. For the example jointed with this post I use a delimiter ":" to identify the text to extract.
Thanks for any helps.
Hello,
I can't figure out how to search for way to extract data from a text string and move the extract data to a new column. For the example jointed with this post I use a delimiter ":" to identify the text to extract.
Thanks for any helps.
Highlight the column you want then...
DATA --> Text to Columns --> Delimited -->Other (here in the text box put the delimiter you want. In this case it would be a colon.) -->Finish
Just make sure that the column next to your data is empty because it will overright that information.
Good luck.
Abousetta
Or try this Macro
CheersPlease Login or Register to view this content.
TexttoColumns does sound ideal here but re: an iterative approach - I would say that Split is often a little easier to code:
A loop-less approach (again ignoring TtC possibility) could be:Please Login or Register to view this content.
(in both of the above I've assumed final values to be written to F where source is A)Please Login or Register to view this content.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks