Button to format cell contents in Excel

[jimmyfinch]

Hi, i have an excel document which can be 1000's of rows long with the following example values in it...

Item Code QTY
0200109002/009/026/072/202 1
0200109074/012/014 23
200109047 22
0.20.0109262 (red) 21
0200147024 / 29 34
0200147029/040 4
02001.09724/729/706 9
0200109262 (blue) 56
0200109709/701 4
200101247 2
200 101 424 1
200101402 1
200101424 3
26679 D 2
29200-64090-9 43 34
292020G020 22
2T24-01020-C4A 12

I want to be able to run through the whole sheet in on operation and do the following...

a) every value that has information in brackets; have the bracketed information moved into another column.

b)If a value is like 0200109074/012/014 then the first column will be formatted just to display 0200109074 then the other values are put into a new column like... 0200109012/014

c) remove all the dashes, spaces, slashes, full stops etc...

d) If there is anything that the computer can not format, they are highlighted or flagged for manual attention.

Please can someone help me figure this one out as this takes hours each day manually formating/copying test around. If 99% of the work can be easily done by computer and the remaining 1% done myself it will really help.

Kindest thanks,

Jim

 

[AnotherHiggins]

What you're after is a macro.

Please create a new thread for this in forum707.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[jimmyfinch]

Hi, thanks - i have just done this.

Hope someone will be able to help me figure this one out!!

Many thanks,

Jim