extract part of a cell's text
New smartsheet user here.
I have cells that contain dimensions of objects. A cylinder, for example, looks like this: Ø120*12. I need a way to extract just the text to the right of the *, in this case 12, to another cell. Another example: Ø18*1000 would return 1000.
How do you do this?
Help Article Resources
Check out the Formula Handbook template!