How Do I Replace The Last Character Of A String In A Macro?

**pablowilks** · 06-07-2012, 05:58 PM

Hi guys

Im sure this is pretty easy but if i have the string:

"Dining Tables, Dining Room Seating,"

How do i turn it into the following:

"Dining Tables, Dining Room Seating and more."

thanks

**jeffreybrown** · 06-07-2012, 06:09 PM

Let say Dining Tables, Dining Room Seating is in A1.

In B1, =A1&" "&"and more."

If you must have a macro...

Please Login or Register  to view this content.

**Andy Pope** · 06-08-2012, 03:44 AM

You need to remove the final comma before appending the text.

=LEFT(TRIM(A1),LEN(TRIM(A1))-1)&" and more"

Please Login or Register  to view this content.

**pablowilks** · 06-08-2012, 02:21 PM

thanks, works great!

How Do I Replace The Last Character Of A String In A Macro?

LinkBack

Thread Tools

Rate This Thread

Display

How Do I Replace The Last Character Of A String In A Macro?

Re: How Do I Replace The Last Character Of A String In A Macro?

Re: How Do I Replace The Last Character Of A String In A Macro?

Re: How Do I Replace The Last Character Of A String In A Macro?

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions