Search results

thats ammmmmazing, thank you who ever you are love paul x x x x x

I have the current cell in excel with the data input into it with the following format: Mr DAVIES Michael As I have over 4000 entries in this format I would like a macro or formula of some sort that will automatically reorganise the cell into the following format: Michael Davies or...

:D yay it works!! just need to do the same for a few more graphs and im sorted!! cheers for the help very good indeed!! Paul

hi, thanks for this, i will have a play with the information you have given me this afternoon, i get the general concept so may be able to do it or get somewhere close!! if not i will let you know!! but thanks again for your time and effort in explaining it!! Paul

thank you for the reply, sorry ive not been in the office again since i left hte post, but i have done this today and managed to get up to where you left it done without to many problems, so i think i am now upto trying the next section!! Thanks Paul :)

good morning chaps, i have set u a spreadsheet which produces a number of graphs, every month i add new figures to the spreadsheet and the graphs then need updating. the graphs have a column on them for each month. at the moment i have to go into the 'source data' for each graph in...