-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
split string
-
C
VBA Split not working
Hi all No doubt an easy fix to this. I have the following code whereby i'm trying to split a two word string into just the last word. The string originates from a combobox selection: Private Sub FamilyCombo_Change() Dim Coat As String Dim Coaty As String Coat = FamilyCombo Coaty =...- Charmwah
- Thread
- coat combobox populate range split string string vba
- Replies: 7
- Forum: Excel Questions
-
P
Function to Split a String
I'm trying to split a String to get, in my case, product name. I am writing the function as a reference to the full string. The strings all start with "SKU-", the Product Name, then product description. Ex. <tbody> SKU-123ABC-Doodad </tbody> I can't simply do text to columns because...- PRobinson87
- Thread
- replace right function split string
- Replies: 4
- Forum: Excel Questions
-
F
split string separated comma
Hi, in filed I have couple of value separated by comma like below: <tbody> A1 header1 B1 header2 C1 header3 Audi 592035, 579733, 653749, 579735 20 000 </tbody> If my macro found that string (always will be separate by ",") should split the string and add rows (= to number of...- Forestq
- Thread
- lbound split split function split string ubound
- Replies: 1
- Forum: Excel Questions
