From the course: Excel Weekly Challenge

Unlock this course with a free trial

Join today to access over 24,000 courses taught by industry experts.

Correct city names

Correct city names - Microsoft Excel Tutorial

From the course: Excel Weekly Challenge

Start my 1-month free trial Buy for my team

Correct city names

“

- [Instructor] We held some workshops around the world over 16 weeks and now it's time to do some analysis. There's gonna be a problem because we've looked at the data and we see NYC, but we also see New York in certain places, like cell J3. That's not gonna work and that's where your help is needed. Please go in and replace every NYC with New York. Pause the video, clean that up, come back and I'll show you a solution. Let's get this cleaned up. I'm gonna go to find, select and go replace. Find what, NYC, replace with, New York. Replace all, eight replacements. Now we can pass this on for someone to do the analytics.

Contents