Using the CHOOSE formula

I am trying to pick up the last 7 character into a new adjacent column, but I DONT KNOW HOW could someone help please?

Regards

tropezfn

Originally Posted by tropezfn

I am trying to pick up the last 7 character into a new adjacent column, but I DONT KNOW HOW could someone help please?

Regards

tropezfn

Hello,

Not quite sure what you mean, I'm assuming that you want to extract the last 7 characters from the adjacent column, if so try this, again assuming your data is in A1

=RIGHT(A1,7)

oldchippy