excel macro request

**long7time** · 05-09-2008, 12:10 PM

Hi
I would like to create a macro that performs the following task. please let me know if this is possible and how it would be done.

I want to copy text from a range of individual cells and then paste all of the individual cells copied and paste this data into a single cell with all the text separated by hyphens between the texts.

Example attached

If you are a macro writer i have a project that i need to complete. you will be compensated for your time.

**BigBas** · 05-09-2008, 12:23 PM

Question:

Would you prefer a macro, or a userform that you can then input information to and have it hyphenate it?

Edit: Try this file.

Click the button to open up the userform. Next, you can drop down the text box and select the range to work on. Finally, click Hyphenate, and it will Hyphenate the selection, and place it in cell J13. Let me know if it works, and we can tweak it to perfection.

Otherwise, you can use this macro approach:

Please Login or Register  to view this content.

**long7time** · 05-09-2008, 12:47 PM

I would perfer a Macro

**royUK** · 05-09-2008, 12:51 PM

long7time

Welcome to the Forum

Please read the Forum Rules & use suitable Thread titles

**royUK** · 05-09-2008, 01:01 PM

Here's another macro

Please Login or Register  to view this content.

**rziegler** · 05-09-2008, 01:12 PM

I think there's an Excel Addin that can do what you're wanting to do.

ASAP UTILITIES is a GREAT timesaver. I don't think anyone that uses excel every day should be without it.

One of the features is the ability to merge cells and separate data by any characters.

http://www.asap-utilities.com/

Use the merge columns or rows ability to merge the data... I hope this helps. If it doesn't work exactly, there ALWAYS seems to be a way for me to do what needs to be done in ASAP. Sometimes it just takes more than one step.

Enjoy!

**BigBas** · 05-09-2008, 01:18 PM

Originally Posted by rziegler

I think there's an Excel Addin that can do what you're wanting to do.

ASAP UTILITIES is a GREAT timesaver. I don't think anyone that uses excel every day should be without it.

One of the features is the ability to merge cells and separate data by any characters.

http://www.asap-utilities.com/

Use the merge columns or rows ability to merge the data... I hope this helps. If it doesn't work exactly, there ALWAYS seems to be a way for me to do what needs to be done in ASAP. Sometimes it just takes more than one step.

Enjoy!

SPAM?? or legit?

**rziegler** · 08-28-2008, 01:08 PM

Originally Posted by BigBas

SPAM?? or legit?

Seriously, if you don't have this utility, you're missing out!

**royUK** · 08-28-2008, 04:49 PM

Originally Posted by rziegler

Seriously, if you don't have this utility, you're missing out!

asap I believe is no longer free, resurrecting an old thread to promote a commercial addin is in my opinion spam!

**rziegler** · 08-28-2008, 05:06 PM

I just haven't been on the forum in a while, and when I saw that something I had posted was questioned as spam I wanted to clarify that I was giving a sincere suggestion. ASAP is free to non-commercial users, and I am in no way an affiliate of ASAP. I just use their tool(s) at least 20 times a day, and thought it would solve the original poster's problem quickly.

I apologize for any confusion or wrongdoing on my part. I won't post about it again, unless I see somewhere it will be of use… if that’s not OK, please email me.

I also didn't intend to re-open an old thread as spam, again, I just wanted to clear up any misconceptions. Please close this thread down if it will cause a problem!

Best Regards