Copying a part of a cell

[buhaj47]

How to copy only a fragment of a cell? What I mean is let's say I have 'BL210' in a cell. What is the formula that would allow me to copy only '210' into a different cell?

[mrice]

=Right(A1,3)

[jeffreybrown]

See this thread, post #5

http://www.excelforum.com/excel-gene...in-a-cell.html