[Solved] Extract numbers to a character

[edneco]

Hello everyone. I have a doubt that I can´t solve it and need some guidance here.

I want to put in another cell the numbers before the point. And in another cell the numbers after the point.

Example:

A1 - 1124.2356
B1 - 1124 (what I want)
C1 - 2356 (what I want)

How can I put this in a formula? I´ve been trying with Left and Right formulas (with search function in the middle) but when I change the numbers (like 112.23) it won´t work properly. Sometimes appears with the point or sometimes is missing a number.

Can you, guys, help me on this?

Thank you in advance for any help.

Best regards,
Eduardo

[robleyd]

For B1, one possibility:

Code: Select all

=LEFT(A1;SEARCH("\.";A1)-1)

I'll leave the other half of the question as an exercise for the student