I am trying to split a cell into 2. I have a cell that may contain "##" after decimal number and I would like to separate the numeric into one cell and the "##" into another.
For example "36.82##" should be split to "36.82" and "##" but "0" would just be "0" and "". Also there may only be one decimal so "30.1##" gets "30.1" and "##" and lastly "27.22" remains "27.22".
I have tried =LEFT(E2,FIND("#",E2)-1) but the cell just returns #VALUE
Any ideas would be great.
Thank you
Bookmarks