Extract a number of characters
Posted by Jennifer on January 08, 2002 9:52 AM
Here is my quandry:
In column A there are cells containing 20 characters or more.
I would like to somehow extract the last 10 characters from each cell and put them into the neighboring cell in column B.
Any suggestions? I would love help from anyone!!!
Posted by Dan on January 08, 2002 9:55 AM
In cell B1 use the formula:
=RIGHT(A1,10)
and copy the formula down column B
