How do I remove duplicate numbers from a cell?

StreekyD,

Your profile says Excel 2010 and you've uploaded an .xls file. Is backwards compatibility to be considered? There are limitations to this file format. One of them is a lower restriction on the number of nested functions.

If I can do this in .xls at all (formula-wise) I will likely need to use many helper columns. Otherwise a VBA solution may be your best bet. I am not currently VBA proficient.

What would you like to do?

Hi StreekyD,

Here is how to accomplish this wih VBA:
from http://www.extendoffice.com/document...string.html#a2

1. Copy code below
2. Press Alt and F11 on your keyboard to open VB Editor
3. Click on Insert and select Module
4. Paste code into Module and close VB Editor.

Don't forget to save your worbook as Macro-Enabled workbook.

Please Login or Register  to view this content.

then use this custom formula (UDF) =RemoveDupes(A1) to get unique values

Originally Posted by StreekyD

Thank you for the response.
So when I save stuff in excel what format should I save it in?
I use MS Office 10

Go to File, Save As, where Save as type: Excel Macro-Enabled Workbook (*xlsm)

Enter formula in B1 and copy down

=RemoveDupes(A1)

Data Range

	A	B
1	FW00526, FW00526, FW00526, FW00526, FW00527, FW00527, FW00527, FW00527, FW00527	FW00526, FW00527
2	FW02510, FW02510, FW02510, FW02510, FW02510, FW02510, FW02510, FW03866, FW03866	FW02510, FW03866
3	FW00722, FW00722, FW00723, FW00723, FW00749, FW00749, FW00749, FW00756, FW00756, FW00757	FW00722, FW00723, FW00749, FW00756, FW00757
4	FW00727, FW00727, FW00727, FW00738, FW00738, FW00738, FW02015, FW02015	FW00727, FW00738, FW02015