Replace multiple columns in once.

CanBilgekan

New Member
Joined
Jan 15, 2015
Messages
5
Hello,

I very new in Excel.
I need to change my columns data with my original data.

ColumnA ColumnB ColumnC
green tom table
blue james chair
blue tom wall
blue marie table

I need change this values with another.
If ColumnA cell = green then new value is 1
if ColumnA cell = blue then new value is 2
etc.
How can i achieve this?

Thanks in advance
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
Welcome to the forum

you can use a FIND and REPLACE, that's if you intend overwriting the original data

Select column A, Press CTRL+H then in the find box, type "GREEN" and in the replace box, type 1 and click "REPLACE ALL" and repeat for blue
 
Upvote 0
Thank you for reply.
I've 10 columns and i need to do that every day.
I think write some codes for this regular operation will save my time.
 
Upvote 0
Thank you for reply.
I've 10 columns and i need to do that every day.
I think write some codes for this regular operation will save my time.

Agreed. But you can always highlight the 10 columns and then perform the find and replace as i described above

Which 10 columns are those?
How many replacements will you be making? (2 i.e green and blue for example) or much more
 
Upvote 0
Agreed. But you can always highlight the 10 columns and then perform the find and replace as i described above

Which 10 columns are those?
How many replacements will you be making? (2 i.e green and blue for example) or much more

Thank you for reply.

Column1 with 10 different values
Column2 with 9 different values
Colum3 and Column4 with 4 different values
Column5 with 5 different values
Column6 with 18 different values
Column7 with 3 different values.

and sheet has about 2000 rows.
I need to do that every day.

Thanks in advance
 
Upvote 0
Do you have the values stored somewhere? say a table that shpws which word to find and which to replace it with and which column it relates to?
 
Upvote 0
I need to define its in vba code.
like this
If cell a1 contains "green" then new value is "1"

Regards
 
Last edited:
Upvote 0

Forum statistics

Threads
1,223,098
Messages
6,170,106
Members
452,302
Latest member
TaMere

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top