BREAK and COMBINE Name's

No Comments
Hey Guys!!!

Perhaps some time you find that you have to break name into Prefix, First Name, Middle Name and Last Name or you have to combine all these to get Name.If it is one time then you can do it manually. But if it is in whole data then what would you do?

Here's a example in which you can break or combine a name fields using formulas. See how it is being done:-



CONVERT DATE FORMAT

No Comments
Hey Guys!!!

Perhaps some time you find that you have to convert the date format as shown below:-

24/02/2018  >>>>>>>  24th February, 2018. 

and If it is one time then you can do it manually. But if it is in whole data then what would you do?

Here's a example in which you can change it using formulas. See how it is being done


Amazon

Is this article helpful to you?