+ Start a Discussion
Vrushali Mali 4Vrushali Mali 4 

how to use LEFT RIGHT and MID function

Hello people,

i Have Account Name for eg MEDITERRANEAN SHIPPING LTD CO and i want to display MEDSHI  that is first 3 letters of the first word and 3 letters of the second word. And it should apply for all account.
Hi vrushali,

Try this way out for building your Text ,

MID(Name , 0, 3) &  MID(Name ,  FIND( ' ', Name)+1  , 3)

If you found this answer helpful then please mark it as best answer so it can help others.

Tania B GarciaTania B Garcia
Hi Akshay_Dhiman

I have a case where I have the Amount field which comes in a description field, then I'm using the LEFT and RIGHT MID, since the amount may vary in numbers, could you please help me to know how to use it when working in varying lengths
an example is
Amount: $ 500,000.00
Amount: $ 78,546,000.00
Amount: $ 7,963,877,100,300,000.00

Thanks and Regards
Tania García