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
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 ANTWORTEN 0
Beschriftungen