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
Polls
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
Don’t ghost us—pick your favorite now!
Labels