split function

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

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

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

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

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

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