Sub String on the String

For Example i have a string of length 500 characters
i need to display the First Ten letters then rest is .......

Which Function i need to use to get this

in Programing Langue we writte like below
SubString(string, 5)+.....
this will give First Five Character then rest is ....

Try this

=left()

1 Like