• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Splitting numbers and text to their respective columns

R

RAM72

Member
Hi All

Need help to splitting numbers and text separately to their respective columns

Annexed file for reference

thanks
 

Attachments

  • SPLIT TEXT AND NUMBERS.xls
    14 KB · Views: 8
If all the entries purely have "ea"
B3: =LEFT(A3,LEN(A3)-2)
C3: =RIGHT(A3,2)

But if you have other units I'd suggest
B3: =LEFT(A3,FIND(".",A3)+2)
C3: =RIGHT(A3,LEN(A3)-LEN(B3))

Copy both equations down
 
You must log in or register to reply here.
Back
Top