Hey. I was hoping you could help me with a macro that could do the following in excel.
\r\n
\r\nI have a list of 80,000 words that need synonyms. Instead of typing these all in manually I was hoping there would be some way of automating the process. In Column A there is a word, Column B will be where the synonyms will be placed.
\r\n
\r\nThe macro will go through the list of words row by row and place the synonyms in the column beside the original word & each synonym found would be separated by | in Column B.
\r\n
\r\nExample of one row once its completed:
\r\n
\r\nA1: abandoned B1: deserted|discarded|forsaken
\r\n
\r\nI have already read all the information available about the subject with no success. Your help would be greatly appreciated. Thanks in advance.