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...

Sub ReplaceString()
    Range("A1").Value = Range("A1").Value & " and more."
End Sub

**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"

range("B2")=Left(trim(range("a1")),len(trim(range("a1")))-1) & " and more"

**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

Hybrid View

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