Hi,

I'm not sure where these spaces are that you refer to, you haven't been clear.  But if you are trying to remove spaces from the start and end of strings you can use TRIM().

Regards

Phil

Hi Philip,

In between cells this is due the removal of duplicates using this formula : =IF(COUNTIF(G$2:G2,G2)=1,G2,"*") 

COLUMN G                                                 

@carige.it
@ceresioinvestors.ch
@bancaditalia.it
@bancaditalia.it
@bancagenerali.it
@mediolanum.it
@mediolanum.it
@popso.it
@bancobpm.it
@yahoo.it
@bancaditalia.it
@yahoo.com

COLUMN I

=IF(COUNTIF(G$2:G2,G2)=1,G2,"*")     

@carige.it
@ceresioinvestors.ch
@bancaditalia.it

@bancagenerali.it
@mediolanum.it

@popso.it
@bancobpm.it
@yahoo.it

@yahoo.com

ON COLUMN J ( the results that I want it to look like is like this) what formula should I use?

@carige.it
@ceresioinvestors.ch
@bancaditalia.it
@bancagenerali.it
@mediolanum.it
@popso.it
@bancobpm.it
@yahoo.it
@yahoo.com

Thank you so much!

Hello,

Depending on what version of Excel you use, if you use Excel 365 then chances are that you can use the new functions. Here are some good articles about them.

https://www.myonlinetraininghub.com/excel-sorted-dynamic-unique-list
https://www.myonlinetraininghub.com/excel-dynamic-arrays
https://www.myonlinetraininghub.com/excel-functions/excel-filter-function
https://www.myonlinetraininghub.com/excel-functions/excel-unique-function
https://www.myonlinetraininghub.com/excel-functions/excel-sort-function

Also depending on what you are to do with the result, but if you only want a unique list you can use a Pivot Table.

Based on what I see in your sample file I would use Power Query to get needed data.

Br,
Anders