MARK858
MrExcel MVP
 Joined
 Nov 12, 2010
 Messages
 13,336
 Office Version

 365
 2010
 Platform

 Windows
 Mobile
Hi there, hopefully an easy question for someone out there. Does anyone know a formula to remove the numbers from a cell with the layout as below;
and so on....
The cells are aligned to the right if that is any help
Cheers in advance for any suggestions.
AB19S02 becomes ABS
BG36Z07 becomes BGZ
GH68L75 becomes GHL
and so on....
The cells are aligned to the right if that is any help
Cheers in advance for any suggestions.