2021-12-25

Excel Formulas: Splitting data in a cell

I am coding an Excel sheet and need to split data from a cell that is formatted as a percent with a code in front of it (e.g. "RPD 4.4%").

I want this formatting to remain the same in the original cell but only want to pull in 4.4 to the desired cell.

What is the simplest equation that I could use to do this?

enter image description here



from Recent Questions - Stack Overflow https://ift.tt/3ekr89w
https://ift.tt/3qqZ8GK

No comments:

Post a Comment