as split these numbers with the formula in 2 columns?
before
12,25
9,899
458,966
44,55
0,987
1155,006
77,88
4589,32015
after
12 25
9 899
458 966
44 55
0 987
1155 006
77 88
4589 32015
Thank you in advance.
max_max
-------------------------------------------------------
Come dividere questi numeri con virgola in 2 colonne?
prima
12,25
9,899
458,966
44,55
0,987
1155,006
77,88
4589,32015
dopo
12 25
9 899
458 966
44 55
0 987
1155 006
77 88
4589 32015
anticipatamente ringrazio.
max_max
Hi Max,
I would suggest that you upload a spreadsheet sample with your data. Your post can't tell us what the properties of your data are.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Hi Alkey
split number.xlsx
=INT(A2) and =MID(A2,FIND(".",A2)+1,255)+0
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Left Part
=VALUE(LEFT(A2,FIND(".",A2)-1))
Right part
=VALUE(RIGHT(A2,FIND(".",A2)-1))
Thanks alkey - martindwilson
folmule the work.
Translated into Italian
martindwilson:
=INT(A2)
=STRINGA.ESTRAI(A2;TROVA(",";A2)+1;255)+0
alkey:
=VALORE(SINISTRA(A2;TROVA(",";A2)-1))
=VALORE(DESTRA(A2;TROVA(",";A2)-1))
Thank you.
Greetings from Italy.
max_max
-------------------------------------------------
Grazie alkey - martindwilson
le formule funzionano
Tradotte in italiano
martindwilson:
=INT(A2)
=STRINGA.ESTRAI(A2;TROVA(",";A2)+1;255)+0
alkey:
=VALORE(SINISTRA(A2;TROVA(",";A2)-1))
=VALORE(DESTRA(A2;TROVA(",";A2)-1))
Grazie.
Un saluto dall'Italia.
max_max
Last edited by max_max; 11-10-2013 at 05:08 PM. Reason: translation error
You're welcome. Don't forget to thank those who helped by clicking on Add Reputation * and please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools-> Mark thread as Solved).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks