Forum Discussion
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 in a column and relabel them accordingly. Is there a fast way to do this?
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'.
2 Replies
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.
