If you're new to macros, you could try to use the recorder (Tools/
Macro/Record New Macro), use find and replace, and stop the recorder.

This would create a macro that you could run again in the future. It
also is a great way to learn how macros work because if you edit the
macro (Tools/Macro/Macros/Edit) you can see what the recorder has
collected. Note that recorded macros contain every option, even those
you did not select, so they get a little wordy sometimes.

On Jan 16, 1:22 pm, Jorge wrote:
Hello, me again, another question to elaborate further on my last
post/question. Is it possible to creat a program/macro that would eliminate
certain words from certain columns and leave the rest of the information
intact. For example:

A1 B1 C1
State: Florida Phone: 321-555-1234 Company: ABC Store
State: New Mexico Phone: 214-555-9876 Company: XYZ, LLC.
State: Georgia Phone: 305-555-4321 Company: Stuff, Inc.

I would like to get rid off the words "State", "Phone", and "Company" so my
columns would look like this:

A1 B1 C1
Florida 321-555-1234 ABC Store
New Mexico 214-555-9876 XYZ, LLC.
Georgia 305-555-4321 Stuff, Inc.

A macro would make things so much faster for me. Thanks again!!!

Jorge