Taking certain text from a column and creating a new column

28985RPB309190

2750932B123925

 

The above string of numbers & letters. I am trying to take only the first 5 or 7 numbers and concatenate a new column with just that,

can this be done??

 

By: Joy

Leave a Reply

Your email address will not be published. Required fields are marked *