If value in cell look in next column and replace it VBA

[ghostexcel]

hi all,

working on this:

Basically, I have value in columns A and B:
Capture.PNG



I would like to write a function so in the column D the text would be replaced from value in A to value in B.

so in this example, i Would have "t hello y", as "aa" and "bbb" are in the column A and the respectively value in column B are "t" and "y".

should have another function something like:

Many thanks

[walruseggman]

I would like to write a function so in the column D the text would be replaced from value in A to value in B.

This code accomplishes that. I'm a little confused by what you are attempting with the function at the end of your post.

Please Login or Register  to view this content.

[PCI]

Is it really a function you want or just a subroutine ??

[ghostexcel]

Hi and thanks for the subroutine! It works well!

I was thinking about the function as if I have a variable "Text" for all the values in column D and in any other cells, would be easier to have it as function. So instead of declaring columns(4) in "Columns(4).Replace c.Value, c.Offset(0, 1).Value", I would like to have just a variable "Text", so for each "Text" make does changes.

Thanks a lot again!

[walruseggman]

Sorry, I'm still confused. Need to see an example that shows

1) sample data
2) sample formula
3) expected formula output

[ghostexcel]

the subroutine work perfectly and is everything i need. just want to use a function instead, so if I have Text as )String, would be something like:

so if Text contains one of the value in Column A, then replace it with value in column B (exactly the same that you did in the subroutine).

Hope I explained it better and thanks a lot!

[walruseggman]

Please Login or Register  to view this content.

[ghostexcel]

Great, this is perfect! thanks a lot!

[ghostexcel]

Is there any way to adjust this function so is going to replace only the exact matches. For example:


Capture.PNG


so is not going to replace values between text, but only when the exact conditions are met. So in this case is fine if the text in column C is going to be replace as it shown in column E, as "aaa" is going to become "a", "bbb" is going to become "b", but "abaaa" is not going to change, as "abaaa" is not in column A.

Thanks a lot!

Thanks