Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Extract Text from Shape in Excel

nadiahghzli
6 - Meteoroid

Hi community, anyone know how to extract text from shape in excel? 

 

For example, here is the text box in Excel:

Screenshot 2024-06-21 142125.png

 

 

 

 

 

 

 

 

 

 

 

 

I would like Alteryx to read it as two rows:

placeholder

alteryx

 

I tried to follow this https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Read-values-from-a-text-box-pr... , but I could not amend it as a macro. The reason why I want to use macro is because I am running for a few excel files with similar format, which one of the tabs that I need alteryx to read consists of text box. Here is the example data and workflow that I am currently stuck. Thank you in advanced for your help !

0 REPLIES 0
Labels