Changing multiple names to one name in word.

January 18, 2011 at 15:02:51
Specs: Windows XP
I have a word doc (2007) in the word document, there are many names, I want to replace all the names with one name, but I can't select all names at once, I have to do this one by one.. so is there any way to do this at once?

See More: Changing multiple names to one name in word.

Report •

#1
January 18, 2011 at 15:30:26
Can you copy the names into an Excel spreadsheet, use a formula that you can drag down and then copy the results back to word?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
January 18, 2011 at 15:49:54
Can you explain me how to do that, it will really help me a lot.

Report •

#3
January 18, 2011 at 16:08:31
I have no idea what you data looks like, so I can't help.

Post some examples of your data and what you are trying to accomplish and we'll see what we can do.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Related Solutions

#4
January 18, 2011 at 16:39:16
For Example,


XYZ : sjkhskhfsjkdfh

ZZZ : ajkhakdfhdkj

UUU : afadjkfhdkasjfhdkjsh


I want to remove the [XYZ, ZZZ, UUU] all at once with the help of find and replace. Can this be done?


Report •

#5
January 18, 2011 at 17:11:33
I'm sure someone could write a Word macro that can do this, but I don't know much about VBA for Word.

However, I copied your example into Excel and used this formula to remove the first 6 characters of each string:

=RIGHT(A1,LEN(A1)-6)

Leaving me with:

sjkhskhfsjkdfh

ajkhakdfhdkj

afadjkfhdkasjfhdkjsh

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Ask Question