09-28-2006, 12:21 PM
|
 |
"Eagle Eyed" Forum Moderator
|
|
Join Date: 14 Feb 2005
Location: Worcester, UK
MS Office Version:Excel 2003 (Work) and 2007 (Home)
Posts: 6,088
|
|
Quote:
|
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 
|