-
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.
splice
-
J
How to split components of an equation
Say I have the following formula in cell A1: "=100+500" how do I pull that 500 from the formula and put it in B1 using a formula?- jbenfleming
- Thread
- cell formula pull put splice
- Replies: 2
- Forum: Excel Questions
-
D
How to split string using VBA?
For example, I have following string <tbody> SPLICE 3_CON 195_INTERLOCK_18_BROWN I am trying to write VBA code to split it into five and put in different columns like: <tbody> SPLICE 3 CON 195 INTERLOCK 18 BROWN </tbody> </tbody> Any help is appreciated.- dmadhup
- Thread
- con splice split string vba
- Replies: 2
- Forum: Excel Questions
-
Z
How to combine a VBA Text Wrap, and a VBA -Data Valadation list- multi selection splice code.
How would i put the Merge Code and this code together? The point of this code is to make 2 different merged cells have multiple selections on a drop down list. So i have a Data Validation list, and I have this code in there so that i can choose multiple items on the list and it will populate...- zeheckman
- Thread
- comma splice text wrap validation vba
- Replies: 0
- Forum: Excel Questions
-
E
Formatting updated web data
Hi there folks, I am using Excel to download web data and then go on to format it and plot the information over time. The web data is a comma separated table. I can get the data into Excel via the Web Query tool, however, it lumps all the information into one column, when it really needs to be...- ecokev
- Thread
- query splice update web
- Replies: 1
- Forum: Excel Questions
