Duffer2468
New Member
- Joined
- Sep 8, 2014
- Messages
- 8
I would like to have a VBA (or macro if no able) to do a searchof a column and either replace or create a new column with the modifications.
Let's use column A for the data to work with.
I need to have it look at column A and if it see an A, B or C change that valueto a 2
If it see an D, F, or G then change value to a 3
EG
if it see in column A
0019E1E21712
It changes in column A or places in column B
9001931321712
As a bonus it would be great to add 7 characters to the front ofthe string and 2 characters to the back of the string
Thank you
Let's use column A for the data to work with.
I need to have it look at column A and if it see an A, B or C change that valueto a 2
If it see an D, F, or G then change value to a 3
EG
if it see in column A
0019E1E21712
It changes in column A or places in column B
9001931321712
As a bonus it would be great to add 7 characters to the front ofthe string and 2 characters to the back of the string
Thank you