Forum Discussion
Excel Loops to find Integers in a Sequence
Hello Helpful People, I need to apply an excel formula to a string of data. Here is a screenshot of what I am working with: In the sheet, Cell B2 will be automatically input as we...
It is possible. But when I see something like this I ask myself "WHY?!". Why not split the data over three columns, put in some basic formulas and your ready?
Yes, very good point. HOWEVER the data is being populated into the cells via a Microsoft Forms entry and therefore will show up as this string in the cell B4.
I used power automate and it's being sent to Planner Tasks and if I just had 5 10 15, the formatting would be off.
HOWEVER now that I'm typing this, maybe I will just input the "$" "m" into the planner task and do what you're saying on individual form entries....
Thanks for the new perspective haha.
I'll work on that but if anyone does want to provide how to do it, that'd be a cool learning experience.
I used power automate and it's being sent to Planner Tasks and if I just had 5 10 15, the formatting would be off.
HOWEVER now that I'm typing this, maybe I will just input the "$" "m" into the planner task and do what you're saying on individual form entries....
Thanks for the new perspective haha.
I'll work on that but if anyone does want to provide how to do it, that'd be a cool learning experience.