Related Posts
Great idea! 👏
Additional Posts in Excel Genius
Still don't have xlookup. #fomo
Would anyone be willing to teach me vlookup?
New to Fishbowl?
Download the Fishbowl app to
unlock all discussions on Fishbowl.
unlock all discussions on Fishbowl.






Coach
You loop through the cell and pull numerical characters:
Like this - there are always edge cases (e.g., what if the input cell contains “23%” - should it out “23” or “0.23”), but this is the basic idea
Use substitute formula to remove them.