Is there a formula I can use to pull only some data from a cell into another?
C11 contains: 0.10 0.42%
I want C4 to contain: 0.10
I want D4 to contain: 0.42%

I would appreciate the help and if there is a formula I would really love to
understand what it means and how it works. Thanks!