1 reply to this topic

[sballen]

How do I ask this in a way to make you understand what I am looking to do?

I am creating an excel file, (.txt format) for my oscommerce site. I am trying to change three columns
into one column. (In the v_products_image column, I need to add two coluimns to cut out and join in with the v_products_image column. ({column A] folder - [column B] image - [column C] _360.jpg) to [column A] folder/image_360.jpg.

Now if these were already in one column I would know how to cut them out to make two columns. But to do it the other way, I don't know how, and can't figure it out.

Can anyone help, can this be done?

That's Column A, Column B. and Column C, joined together to Column A.

Thanks

[kymation]

=CONCATENATE(A1; B1; C1) to combine columns A, B, and C. Modify as needed.

Regards
Jim