Home > IT Answers > Microsoft Windows > Excel Macro to extract substrings from a comma-separated string.
Sdsdsd
15 pts.
 Excel Macro to extract substrings from a comma-separated string.
Microsoft Excel, Microsoft Excel formulas, Microsoft Excel macros, String manipulation
How can I write an Excel macro to exctract substrings from a comma separated string located in a single cell and put each substring in a cell of a certain column.

Software/Hardware used:
ASKED: April 12, 2009  6:17 AM
UPDATED: April 13, 2009  3:18 PM
RELATED QUESTIONS
Answer Wiki:
Hi you can use the <b>Split </b>function as described <a href="http://spreadsheetpage.com/index.php/tip/the_versatile_split_function/">in this article</a>
Last Wiki Answer Submitted:  April 12, 2009  8:08 am  by  alessandro.panzetta   9,695 pts.
All Answer Wiki Contributors:  alessandro.panzetta   9,695 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

The Split sunction is exactly what I need! Thank you very much! :)

Sdsdsd
 15 pts.