Posts by ablalarom

Hello!

I need to pull out some info from a text string with the following structure:

BRAND/PROJECT NAME/INITIATIVE/MARKET/Ex FACTORY/

I'd like to paste this text and have in the adjacent columns the text for "Market" and "Factory

The pattern shows that factory will always be the last string and the market will be the string before last one. Meaning that the below can happen:

BRAND/PROJECT NAME/INITIATIVE/MARKET/Ex FACTORY/

BRAND/PROJECT NAME/MARKET/Ex FACTORY/

So the order is from right to left.

I've been able to pull out "Factory" by using this formula:

=LEFT(RIGHT(A1,LEN(A1)-FIND("Ex ",A1)-2),4)

However, as there are several "/" in the string, I don't know if there is a way to ask excel to seach the "second ocurrence of the symbol / from the right" or something like that to work with.

Any ideas? Many thanks and the best weekend to you all!

Thank you so much! This worked perfectly & will save me so much time. Thanks again

The path is D:\Freight and it contains the 20 *.xlsm files only. Thanks

Hi all,

I have about 20 excel macro files xlsm all containing a tab called "Freight". I need to have a new excel file (either xlsm or xlsx, I don't care) containing all "Freight" tabs from the 20 files, renamed in some way (because excel won't accept tabs with the same name). It could take cell B7 as name of the file (that field is unique).

I have tried the solution proposed in a previous thread (https://www.ozgrid.com/forum/f…e-workbooks-into-new-file) but it's not working. I have changed the path and the file type to ".xlsm".

I would really appreciate your help.

Thanks!

A.

Hi all,

I have about 20 excel macro files xlsm all containing a tab called "Freight". I need to have a new excel file (either xlsm or xlsx, I don't care) containing all "Freight" tabs from the 20 files, renamed in some way (because excel won't accept tabs with the same name). It could take cell B7 as name of the file (that field is unique).

I have tried the solution proposed in a previous thread (https://www.ozgrid.com/forum/f…e-workbooks-into-new-file) but it's not working. I have changed the path and the file type to ".xlsm".

I would really appreciate your help.

Thanks!

A.

Hi all,

I have about 20 excel macro files xlsm all containing a tab called "Freight". I need to have a new excel file (either xlsm or xlsx, I don't care) containing all "Freight" tabs from the 20 files, renamed in some way (because excel won't accept tabs with the same name). It could take cell B7 as name of the file (that field is unique).

I have tried the solution proposed in a previous thread (https://www.ozgrid.com/forum/f…e-workbooks-into-new-file) but it's not working. I have changed the path and the file type to ".xlsm".

I would really appreciate your help.

Thanks!

A.

Hi all,

I have about 20 excel macro files xlsm all containing a tab called "Freight". I need to have a new excel file (either xlsm or xlsx, I don't care) containing all "Freight" tabs from the 20 files, renamed in some way (because excel won't accept tabs with the same name). It could take cell B7 as name of the file (that field is unique).

I have tried the solution proposed in a previous thread (https://www.ozgrid.com/forum/f…e-workbooks-into-new-file) but it's not working. I have changed the path and the file type to ".xlsm".

I would really appreciate your help.

Thanks!

A.