MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Text to Columns/Parse


Posted by Angela on July 30, 2001 8:11 AM

I have a document with different character lengths. How do I parse the last five digits? For example, I want to parse 123456789 to read 56789 and with the same keystrokes, parse 987654 to read 89654.

Thanks in advance your assistance!!!


Posted by Mark W. on July 30, 2001 8:16 AM

Insert a new column and use the formula,
=RIGHT(ref,5), where "ref" is your cell
reference.