How to use LEFT, RIGHT Functions and add them together

Hi there, I am using =IF(X14=””,””,(LEFT(X14,1)&”/”&RIGHT(X14,1))) for below table 

10.6+ 1/+ 8.8 8/8
7.2 7/2 7.1 7/1
6.4 6/4 6.6 6/6
7.2 7/2 7.5 7/5
7.2 7/2 6.4 6/4

 but apparntly it is not working for 10.6+ , it should be 10/6 .  Is there a formula to resolve this issue pls ?? 

By: Ash

One thought on “How to use LEFT, RIGHT Functions and add them together

  1. SHOUKATH ALI PV

    =LEFT(A1,FIND(“.”,A1)-1)&”/”&MID(A1,FIND(“.”,A1)+1,10)

    10.6+ in A cell will be converted to 10/6+

    if you don’t need +

    =LEFT(A1,FIND(“.”,A1)-1)&”/”&SUBSTITUTE(MID(A1,FIND(“.”,A1)+1,10),”+”,””)

    10.6+ will be converted to 10/6

    this would work for any number with more digits

    like 125500.65558+++ to 125000/65558

Leave a Reply

Your email address will not be published. Required fields are marked *