Function to add text to the end of every cell?

**visionwindowfilms** · 07-07-2010, 11:20 AM

I've got lots of text descriptions inside a number of cells, they all have different text. I need to add a sentence to the end of every one, because the descriptions are different I can't use a simple find and replace to do this as the last word or phrase is different on each one. Is there a way to make this text go at the end of every ells description? (the text to be bolted on the end is the same for all)

**JBeaucaire** · 07-07-2010, 11:32 AM

This macro will do it...

Please Login or Register  to view this content.

How/Where to install the macro:

1. Open up your workbook
2. Get into VB Editor (Press Alt+F11)
3. Insert a new module (Insert > Module)
4. Copy and Paste in your code (given above)
5. Edit the MyStr text to be what you want
6. Get out of VBA (Press Alt+Q)
7. Save as a macro-enabled workbook

The macro is installed and ready to use.
===========

How to use the macro:

1) Select the cells you want to edit, or some of them.
2) Press Alt-F8 and select AddText from the macro list.

**martindwilson** · 07-07-2010, 11:33 AM

just use in a spare cell
=a1&" your new text"
where a1 has original text
you can then copy paste special values to remove the underlying formulas

**Marcol** · 07-07-2010, 11:41 AM

Or

Please Login or Register  to view this content.

**cswminty** · 07-26-2012, 10:26 AM

JBeaucaire

That worked perfectly to add an @email address to my filed.

Thanks you for saving me soooo much time
Chris.

**mfawadg** · 09-15-2012, 07:16 AM

THanks Jbeaucarie

**sheilazim** · 11-13-2012, 12:13 PM

Thank you worked like a charm!!

**dimitkoster** · 01-08-2013, 03:29 PM

this is what I was looking ,thanks.

**dawncho** · 10-21-2013, 06:30 PM

Thanks for this!

Function to add text to the end of every cell?

LinkBack

Thread Tools

Rate This Thread

Display

Function to add text to the end of every cell?

Re: Function to add text to the end of every cell?

Re: Function to add text to the end of every cell?

Re: Function to add text to the end of every cell?

Re: Function to add text to the end of every cell?

Re: Function to add text to the end of every cell?

Re: Function to add text to the end of every cell?

Re: Function to add text to the end of every cell?

Re: Function to add text to the end of every cell?

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions