Looping using left function resulting in Concatenate

[jaimie1664]

Hello Everyone - I am trying to produce a loop that loops through a vertical columm picking up the cells string that starts with "AGL" and puting an "&" on the end and untill it reaches a blank column. The best i have come up with is but not working, can anyone help?

Please Login or Register  to view this content.

can anyone help please


thanks
Jay

[Marcol]

Hi jaimie

Please wrap your code in code tags, before the moderators get you...

Forum rules

3. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # button at the top of the post window. If you are editing an existing post, press Go Advanced to see the # button.

Cheers

[Marcol]

You Could try this

Please Login or Register  to view this content.

Without some data to work with it isn't clear what you expecting as a result

Hope this helps

Remember the Code Tags in Post #1

[jaimie1664]

You Could try this

Please Login or Register  to view this content.

Without some data to work with it isn't clear what you expecting as a result

Hope this helps

Remember the Code Tags in Post #1

Thanks a lot for your help on the above, But becuase i didnt explain myself very well this isnt what i was looking for. So for example i have a column that looks like this

DGL2279378
BR2 Rev
DGL2279321
DGL2279327

I need the code to go down that column and concatenate all the ones that begin with DGL - so would have an output as follows

(i need the output in a cell say cell 1 column 1) output = DGL2279378 & DGL2279321 & DGL2279327


Thanks a lot for any help

Jaimie

[Marcol]

To avoid further confusion post a sample workbook showing some typical data that you have in columns K & L and on a separate sheet in the same workbook, the result you expect.

[jaimie1664]

Hi - Please find attached example data and the output i am looking for


Thanks
Jaimie

[Marcol]

Try this

Please Login or Register  to view this content.

Your sample data doesn't show many variations of what your real data might look like.
I've taken a guess and added some "possibilities"

Best I can do based on info provided.

Hope this helps.