split function

  1. D

    Implement split with address and copy paste using code

    i have two workbooks one that has information put into the other where it will be migrated over to. I can show how it looks below The way the image k ref is, it will contain an address and the split will go in how x ref image shows it. I listed the cells from the other image for reference. Im...
  2. M

    Split function to search for value in worksheet

    Hi and thanks for any help you can give, I am trying to use the code below to extract partial text (Everything before the hyphon) from a textbox (TBRandA). I am then wanting to use this value (JArray) to search and return a value from my worsheet. When i use JArray as part of "Myvalue3" it...
  3. A

    VBA to Paste data into Access table

    I need to copy data from a username/password protected "homegrown" database (that can be a little slow) and paste it into an Access Table. I wrote a macro in our "homegrown" database that I linked to `. I'm able to do the following in Access: Sub AutoExec() AppActivate "Session 1" delay...
  4. 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...
  5. K

    split characters in one cell to columns and create new columns

    I have a table and I need to split characters within a table in easy way <tbody> ID q1 q2 q3 1 0301|0303|0307 07065|07567 090861|090862|090863|090864|090865|090867|090869 2 0301|0303|0307|0308 07565|07567|07569 090861|090862|090863|090864 3 0301|0302 07457|07458 090861|090862 4...
  6. A

    Using split function in vba

    Hello, I have an address string that I need to split up into three cells using vba with the split function. The problem that I'm having is that I can't seem to formulate the functions in which they can handle different forms of the address. For example, New York, NY 23658 should return New...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top