split a word

[MT10]

Hi

can someone advise how to  extract the last/first  few letters of a word/string with and without delimitors

an example from excel point of view:

Left(Orange,2) = Or

right(Orange,2) = ge

rgds

[anurag · Accepted solution]

Hi @MT10 
Can you review this video to use LEFT or RIGHT incorta function:
https://www.youtube.com/watch?v=LlLPQFWvg2k