How to create macro to add data based on relative data?

Hey this is my first post.

I'm creating a macro that will involve some form of if-else/case-switch, as well as a loop (probably), but I'm not too sure how to go about it.

Basically there are records in columns. Lets say Column A has numbers in it, for example

Cell A1 has "Three"
A2 has "Five"
A3 has "Two" all without quotes

I basically want a macro that will loop through the whole column, so if A1 contains "Three" (not case sensitive), then set B1 to "3" without quotes. If A2 contains "Two", then the macro will set B2 to "2" without quotes.

Of course this is sample data but you get the jist. It needs to loop through one column, so as to fill in the other column. You can assume that column A will always be filled, so the macro is being created to automatically fill in column B based on what is in column A.

Any help would be appreciated. Thanks!

for this purpose ...
you have to first define excel that "Two" = "2" (without quotes)....
till your all number gets defined...
ifs and loops come later..

Say thanks, Click *