Search results

Hello All, I was wondering if I could get some assistance. I have started some of the code but missing a vital piece. What I have is two columns, one A with state abbreviation AL, AR etc and one with nine digit number such as 471234567. What I want to do is trim the 471234567 to 47123. I then...

Hello All, I have a piece of code that almost works for what I need it to do. Basically, I have data consisting of a variable number of column separated strings. example 01AL,02AL,03AL,04AL When I run the code below Sub CommaSeparated() Dim curr_range As Range Dim Row As Range Dim arr As...

Hello, I have code that split out cells with semi colon and copies them to cell below. e.g. row1 a;b xxx row 2 c xxx run code and receive row 1 a xxx row 2 b no row data here row 3 c xxx Here is the code. The only problem as you can see above is it is only copying cell down in...

Hello All, I have a file the contains data from column a to g. The data must remain intact. I am looking to write a vba program that will 1) Look to Column B to see if the is data string containing one, two, or three semicolons. The data will be in the format 123, 123;123, or 123;123;123...