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'.
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'.