Split cell

[bosco2]

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

[mcmahobt]

Assuming your data starts in A1, try this:

Please Login or Register  to view this content.

[Evolta]

Split like you wanted

Map_2.xlsx

[bosco2]

THANKS! Is it possible to change that to also just strip out the "##"

Thanks again!

[mcmahobt]

Try:

Please Login or Register  to view this content.

[newdoverman]

Here is another way. With the values in column A and the results in columns B and C:

Enter in column B:

Please Login or Register  to view this content.

Enter in column C:

Please Login or Register  to view this content.