In excel is a feature to extract a requested number of characters (left or right) of a column into a new column.
ie, if column a1 had 9009125439
the formula would look like
which would give a result of 25439.
according to what I saw the RIGHT/LEFT function in eg only realigns the column.
I need to know how/if the right/left excel function can be done in eg. Thanks
Also investigate SUBSTR with the PUT function. If your variable is CHARACTER, then you won't need the PUT function. If your variable is numeric, and large, then you might want to use an explicit PUT function so you can control how the number is converted from numeric to character. SUBSTR only works on character variables.