Formula or code to remove duplicate text or values within a cell

Formula or code to remove duplicate text with in a cell.

I have a data in sheet with multiple columns and rows. Please find attached.
Where most of the cells are contained duplicate or repeated text and values like all duplicate or repeated text and values are separated with “^”. I want to remove all the duplicate and repeated values with in a cell

4BHK^4BHK

Juhu^Juhu^Juhu^Juhu^Juhu^Juhu^Juhu

60000^60000^60000

17,647/Sq-ft^17,647/Sq-ft

Prime property for lease: the apartment with 4 bedrooms, 3 bathrooms, dining and living and kitchen on 7th floor, with east west cross ventilation, excellent natural lighting and unrestricted view is available for lease with following amenities. 1.1495 sq. feet all rooms and kitchen tastefully finished with vitrified flooring 2. all 3 bathrooms finished with designer tiling and customized fittings and water heaters 3. kitchen with granite platform and piped gas connection 4. stilt car parking next to lift entrance.^Prime property for lease: the apartment with 4 bedrooms, 3 bathrooms, dining and living and kitchen on 7th floor, with east west cross ventilation, excellent natural lighting and unrestricted view is available for lease with following amenities. 1.1495 sq. feet all rooms and kitchen tastefully finished with vitrified flooring 2. all 3 bathrooms finished with designer tiling and customized fittings and water heaters 3. kitchen with granite platform and piped gas connection 4. stilt car parking next to lift entrance.



Please note.

* Only duplicate or repeated text and values separated by “^” should be removed. Non duplicated data (Eg. Given below) should not be removed

10000000^1.0 Crore
8500000^85.0 Lac

* Also I will be adding rows and columns time to time. The formula or cde should be applicable to new rows and columns as well.

UDF

Use in cell like

=Uniq(A1,"^")

Please Login or Register  to view this content.

I tried it is not working. Can you please send me in sample fine attached

See..................

Hi,
Gr8.

But it is not working for data like

1) 156/Sq-ft^156/Sq-ft^156/Sq-ft^156/Sq-ft

2) 10,000/Sq-ft^10,000/Sq-ft^10,000/Sq-ft^10,000/Sq-ft



The Result is showing as 5439685 for 1st and 5792148 for 2nd

The result should be 156/Sq-ft for 1st and 10,000/Sq-ft for second

Please help

Hey Sorry,

Its working

Should be....