Forum Discussion
Solved
Changing one character in a column
I am updating door jambs for a new building, in simplifying the labeling we are starting by change one letter on all jambs. OLD ---- 1K308 NEW---- 1B308 I need to go through all the labels ...
Select the column.
Press Ctrl+H to activate the Replace dialog.
Enter K in the 'Find what' box, and B in the 'Replace with' box.
Click Options >>.
Make sure that the check box 'Match entire cell contents' is not ticked.
Click 'Replace All'.
=REPLACE(C3,2,1,"B")Maybe with this formula. In the example i've entered the formula in cell D3 and copied down.
An alternative could be Flashfill.