Excel question

[Sosa]

I'm running the newest Excel program and I'm trying to do a search / replace.

I have two columns, one for my keywords, the next one with a landing page url to match the keyword.

Say I want to search "blue" and replace it with "black"

does anyone know if I can do this in Excel?

[RuthB]

yep, just do a find and replace

in the new excel it's on the far right hand side of the main toolbar for the 'Home' tab

Just select the cells you want to find and replace, then click the button 'Find and replace' on the top right of the toolbar, select 'Replace' and then put in your info.

[Sosa]

Thanks Ruth That was easy enough, I just wasn't looking in the correct spot!

[RuthB]

Thanks Ruth That was easy enough, I just wasn't looking in the correct spot!

haha you're welcome

yeah, the new Excel takes a bit of getting used to. When I first started using it I was all over the place trying to find my drop down menu bars LOL

It is easier once you get used to it though, I definitely prefer the new format.