How to combine 2 or more data cells in one cell

Hi V!o,

I think the best way to do this is with a User Designed Function.

See Attached. vio - Combine 2.xlsm

I hope this helps, please let me know!

Regards,

David


- Please click on the *Add Reputation button at the bottom of helpful responses.

Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".

If several people have responded, when you reply please make it clear WHO you are responding
to by mentioning their name.

Hy David,

That formula works great in this .xlsm file ! but if i want to use it in another .xls file what i must do?

My table/.xls is changing day by day with another COF ID, another pivot table etc.


Thanks for your help !!

Hi V!o,

The UDF requires a macro enabled file. You will have to save the file as XLSM, and store a copy of the macro in the file itself.

ALTERNATIVELY, copy the function GETLOC() into your PERSONAL.XLSB file, then when you use the macro enter it as ='PERSONAL.XLSB'!GetLoc(A2) etc.

Regards,

David

Thanks for your time and your help !!

I gather you sorted out your own problem. Well done.
Regards,

David


- Please click on the *Add Reputation button at the bottom of helpful responses.

Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".

Hello,

I have another question...

It's that possible as location (column J) from sheet 2 that are repeated to be underlined in sheet 1,column D?
Conditional formating is not helping me in this case because in sheet 1 column D is a formula(macro).

Thanks