Robert87
11-29-2016, 03:59 AM
Hello.
I have a spreadsheet where I want to find certain cells and add text to them.
Every week I get a workbook sent to me by a colleague of mine.
All cells in the C columns should contain the ID number of a drawing. The ID numbers look like this: M3TR-1***.
Sometimes when I get the workbook, the creator have forgotten to add the "M3TR-" part, and have just written "1***".
I´ve been trying to find a way to locate all cells in the B column which contains this error and correct it.
Could anyone of you fine experts help me with this?
Example:
B5 contains 1208.
I want B5 to be changed to M3TR-1208
B6 contains 1162
I want B6 to be changed to M3TR-1162
I have a spreadsheet where I want to find certain cells and add text to them.
Every week I get a workbook sent to me by a colleague of mine.
All cells in the C columns should contain the ID number of a drawing. The ID numbers look like this: M3TR-1***.
Sometimes when I get the workbook, the creator have forgotten to add the "M3TR-" part, and have just written "1***".
I´ve been trying to find a way to locate all cells in the B column which contains this error and correct it.
Could anyone of you fine experts help me with this?
Example:
B5 contains 1208.
I want B5 to be changed to M3TR-1208
B6 contains 1162
I want B6 to be changed to M3TR-1162