Previous Topic Next Topic

EXCEL VBA macro

Closed
Sam - Dec 30, 2011 at 10:49 AM
 Sam - Dec 30, 2011 at 11:33 AM
The situation is: I have a about 15000 lines of data that needs to be cleansed. I need to change the Item description from e.g

Uncleansed = OFFSET TIB TRAY NEUTRAL ADAPTOR

Cleansed = ADAPTOR OFFSET TIB TRAY NEUTRAL


is there a way I can do this automatically? with a macro?

thanks
Related:

1 response

Answer 1 / 1
RayH
Dec 30, 2011 at 11:07 AM
What rule needs to be applied to produce the desired outcome? Obviously not sorted by name.
Is the data in one cells are the elements in a cell of their own per row?
0
Sam
Dec 30, 2011 at 11:30 AM
Here are the rules

Must follow the inverted nomenclature concept

E,g CATHETER FOLEY SILICONE 2WAY 3CC 24FR BLUE

Basic Noun: CATHETER
First Modifier: FOLEY - adjective ; describes the function
Second Modifier: SILICONE - Adjective ; critical attribute
Third Modifier: 2WAY- Critical attribute/form of use description
Fourth modifier: 3CC Size
Fifth Modifier: 24FR size
Sixth Modifier: BLUE Colour

Basic nouns should not be abbreviated or pluralized. i.e. GLOVE not GLOVES

Description are to be generic e.g use BLEACH instead of JAVEX(Brand name)

No Punctuations in the description
0
Sam
Dec 30, 2011 at 11:33 AM
Here is an extract

Offset Tib Tray Neutral Adaptor
Offset Tib Tray Neutral Adaptor
Offset Tib Tray 2.5mm Adaptor
Offset Tib Tray 2.5mm Adaptor
Offset Tib Tray 5.0mm Adaptor
Offset Tib Tray 5.0mm Adaptor
Offset Tib Tray Adapter Plug
Offset Tib Tray Adapter Plug
Offset Tib Neutral Lock Insert
0

Similar discussions

Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
Create folder in desktop with vba, if exist, ignore
viriato74 -
praveen -

6 responses