Adding to the End of a Character

[Orangeworker]

Hi,

I'm trying to add some text to the end of a character. I'm using find/replace, but can't figure
out the code to put into the find box.

I have a column of text and am trying to add what's listed below at the end of each character
in each cell.

_Add Text

Thanks!

[jaslake]

Hi Orangeworker

An example file would be helpful.

John

[Orangeworker]

Thanks for responding; I've attached a sample.

H

[jaslake]

Hi Orangeworker

I suspect your issue is not as simple as your example. However, if it is, place this code in column B of your example and copy down

Please Login or Register  to view this content.

and you will end up with this in column B of your example.

blue_SampleText
magenta and yellow_SampleText

If your issue is more complicated (you said you were doing a find/replace), then post an example of what you're trying to find and what you'd like it replaced with. Include your existing code as this may give me a clue as to what you're lookig for (or not).

Be glad to help with a bit more direction.

John

[Orangeworker]

Thanks for the help John, that worked perfect! It was as simple as what I had listed
in the sample.

How about adding to the beginning, or changing any of the characters in between with
something else? That would help me out greatly.

H

[usafmeinweg]

just swap "_SampleText" and A1 and now it is in the beginning. Not sure what you are looking for with respect to changing characters in between.

[jaslake]

Hi H
To add at the beginning, expand the Concatenate like this

Please Login or Register  to view this content.

To do this

changing any of the characters in between with something else

I'd need to see examples of what you have in mind.
John

[Orangeworker]

Thanks for the tip, that worked well also. Just trying to figure out some "general" types of code that I could experiment with. Is their anything on this site or somewhere else that lists some different examples?

H

[Orangeworker]

John,

If you have time, I've attached another example called "Sample 2"

Thanks for all your help!

H

[jaslake]

Hi H

Google is your best friend. Try this on Google "Adding to the End of a Character Excel" or this "Adding to the End of a Character Excel VBA" and you'll get more hits than you can deal with. However, if you're persistent, you'll eventually find an approach you can use. If not, come back to this forum and ask the question. That's my approach; it's worked wonderfully well for me.
John

[usafmeinweg]

H
For your example use

Please Login or Register  to view this content.

as for the other functions
try http://office.microsoft.com/en-us/ex...791861033.aspx

[jaslake]

Hi H

In your last example file, you listed one sample. What are the constants in your data? If there are constants, then formulas or code can be written to deal with them. If there are no constants, then all anomalies will need to be dealt with.

I need more information.

John

[Orangeworker]

Thanks again John!

[Orangeworker]

Last question, what if the text in B2 wasn't there and I wanted to list the text in the code?
Then I can experiment with different areas in between the beginning and end. Thanks for your time and patience.

[jaslake]

Hi H
In my experience there's never a

Last question

If that were so, then one has stopped learning and I suspect that you and I have only begun to learn.

Yes, this can be done (I think)

what if the text in B2 wasn't there and I wanted to list the text in the code?

I'll work up some examples for you (probably not tonight) and post them. You can then play with the examples and adapt them to your needs.

With the Easter Holiday, I may or may not get back to you tomorrow.

John

[Orangeworker]

Ha, I totally agree with you regarding the questions, they never stop. Just didn't want to bug you too much.

Take your time and enjoy the weekend; I'll check back on Monday. Happy Easter!

[jaslake]

Happy Easter

John

[jaslake]

Hi H
I think this code addresses your question

what if the text in B2 wasn't there and I wanted to list the text in the code?

Please Login or Register  to view this content.

Play with it and see the results.
John

[Orangeworker]

Thanks John, I will experiment with that.

H