From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 22,700 courses taught by industry experts.

Replace text based on formats, like cell attributes (bold, text color, etc.)

Replace text based on formats, like cell attributes (bold, text color, etc.) - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Replace text based on formats, like cell attributes (bold, text color, etc.)

“

- [Instructor] On the current worksheet, 2 we've got about 700 rows of data. 3 I need to make some changes in column C. 4 A command that's frequently used 5 for changing content is the replace command, 6 but it's also possible to replace content 7 and format together and even replace formats only. 8 In column C, we're about to make a change here, 9 and every time we see the word and, 10 we see project contract services here, 11 we also see engineering and maintenance, 12 and there might be some other departments in here too. 13 We simply want to change the word and to the ampersand symbol. 14 So we're going to select column C, 15 and off to the right, you already see it being displayed, 16 but I'll emphasize the idea. 17 We go to the home tab, find and select and replace. 18 Now, I want to replace the word and. 19 Replace with that ampersand symbol, the and symbol found 20 on the number seven key on most keyboards. 21…

Contents