MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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:


and copy the formula down column B