Search results

Perhaps Fantastic. Awesome thx Luke. Resolved.

Gracias Senior. Works perfect resolved.

If B1 contains text Then Subtract B1's entire contents from A1 (while leaving whatever remains in A1)? My goal is to just minus the string portion out of A1 with whatever was in B1 (If B1 contains text) A2 minus B2, A3 minus B3 etc.. I will need the cell referece as (0,1) - (0,2) though.

Absolutely fab. But it throws the brace "{" on all last spaces in every string. The "{" is backwards in the code above but that's ok ; ) However, do I tweak it so it only places it on strings that end with "}" I was trying to use this below but it doesn't work. FindLastBrace = Mid(Cell...

Luke, am I close? Sub Add_Brace2LastWord() Dim Cell As Range Dim MyString As String Dim FindLastBrace As String For Each Cell In Range("A1", Range("A65536").End(xlUp)) MyString = Cell.Value FindLastBrace = Mid(Cell, Len(Cell) - 1, 1) If FindLastBrace Like "}" Then MyString =...

How do I find the last space in a string, and replace it with "{" ?

I emailed it, thx Hui as always.

I'm not sure I understand your query. Strings are in 5 groups: 1. basic structure with problematic value on the end of string 2. basic structure with problematic value at the start of string 3. with link located in the middle of string 4. with link located at the start of string 5...

Hmmm Interesting.. Much appreciated Dan ; )

Please have a look. The expected results sheet doesn't have those extra spaces like last time. There are buttons for everything. http://www.iandmyself.me/Kill.Links.Epitome.Example.xlsm I can't imagine a more full story than this link. These are carefully created messy url strings in...

My ultimate ultimate ultimate goal is to trapped all links in my worksheet with braces, and then delete them {*}. {http://www.iandmyself.me} Some links have ID URLStartMarkers eg: http www etc.. All links have ID URLExtentions .com .net .me etc.. I have to drop a brace in before...

Resolved! Thanks Hui you're awesome! Sub DifferentiateDots() Application.ScreenUpdating = False Dim c As Range Dim b1 As Integer Dim b2 As Integer Dim midstring As String Dim MyString As String For Each c In Range(Cells(3, 1), Cells(3, 1).End(xlDown)) MyString = c.Value If...

Here is a tricky one. Good ".me" = "(iandmyself.me)" Bad ".me" = "(KeyWorded problematic value.me)" How do I ONLY change the bad dot in "(KeyWorded problematic value.me)" to another character (or word)? It's tricky because I won't know what any of this text is other than ".me" and...

Is there a way to select a clunk of code in the editor and click some option that places hash marks in front of my lines of code? Is going down the front of every line manually the only way? I mess up a lot. '''Sub MyCode() '''If every line doesn't work Because _ '''I have no idea what...

How long have you been doing this? That was way too fast. People who can do stuff like this should have super models making them breakfast every morning ; ) Resolved.

Various is just a random word I used for this post example. I'll never know what various is. Various could be: {HttpVariousBlahBlah -or- BlahBlahVarious.com} I place the first brace against the part in the string I can identify as a partial link match, and I was needing a code that...

I have a pretty good idea who will help me with this. I think we should all go jet-ski fishing some time. It's a lot of fun if you can get past the ridiculous part (jk). This is my very very last and final request on this issue. I know this is a place to ask questions, but I know I must...

Thanks for this guys. It worked perfect. Resolved.

Hui, VJay, Luke, I appreciate the help. Luke you're right. Looping through the cells just to check takes more time, on top of time. I ran a timer and it was 6 seconds longer just to check first. I guess I shouldn't be so OCD about removing every possible link in the world. I'll just...