In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
Start Free Trial

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
Top Solution Authors