Recent content by tyantorno

Thank you so much Jiri, that works great. I really appreciate it. Have a great day!

Thank you Plog, I will look at your suggestion, great information. Have a great day.

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

Thank you so much RX, i will surely look into that link. Have a great Thanksgiving. Tom

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 Brian, Thank you so much, that worked perfectly. You are very helpful. Have a wonderful weekend! Tom

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

Thank you so much, I think I got it. You have been very helpful. Have a great weekend.

Hello, Yes it works great. I have been trying to get the bold font for copied cells but have been unsuccessful. If you could give me some pointers would be great, again thank you for your assistance! Tom

Yes, file would be excel spreadsheet. Thank you

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