I have a large spreadsheet with cell that contain similar older catalog numbers. Want to update to the latest version of catalog number.
Can I delete/ remove a character from the following
Example: 23LB412 take out the "B" and keep the following:
EXCEL 7, Windows Vista
March 11, 2013 6:26 PM
March 11, 2013 6:45 PM