ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. 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