Subsitute more than one words in the columns

[weakinexcel]

I need to change words in first columns and replace it in the next columns. There are too many cells for me to change.
For example,
A1: Slight
A2: Moderate
A3: Slight
A4: High
A5: Calm
A6: Rough
A7: Very Rough
A8: Calm

I need to change it to
B1: 1111
B2: 2222
B3: 1111
B4: 3333
B5: 4444
B6: 5555
B7: 6666
B8: 4444

Is there any easy way like macro?

 

[hiker95]

Hi Hiker95,

Thank you so much. This is what i need.

weakinexcel,

Thanks for the feedback.

You are very welcome. Glad I could help.

And, come back anytime.

 

[hiker95]

Hiker 95, i need to decode back from numbers to words after everything is done but at a different sheet is there any macro i can use it for?

weakinexcel,

In order to continue, and, so that I can get it right on the next try:

Can you post a screenshot of the actual raw data worksheet?

And, can you post a screenshot of the worksheet results (manually formatted by you) that you are looking for?

To post a small screen shot (NOT a graphic, or, picture, or, PNG file, or, flat text) try one of the following:

MrExcel HTML Maker
If you do not know how to install and how to use HTML Mr.Excel Maker
https://www.youtube.com/watch?v=JycvgGppxt0&feature=youtu.be

Excel Jeanie
Download

Borders-Copy-Paste
http://www.mrexcel.com/forum/about-board/444901-how-create-table-like-aladin.html#post2198045

To test the above:
Test Here


The following is a free site:

You can upload your workbook to (the BLUE link-->) Box Net ,
sensitive data changed
mark the workbook for sharing
and provide us with a link to your workbook.