Worksheet Function to Edit Numbers

[raywood]

I have approx. 400 seperate entries that I need to change from
21/07-13-031-29W3/0 ....to.... 121071303129W300.

Can this be done with excel wks functions...if so how?

raywood

[Ikaabod]

Depending on what you need... if the format of the data stays the same then this should work:
=1&LEFT(A1,2)&MID(A1,4,2)&MID(A1,7,2)&MID(A1,10,3)&MID(A1,14,4)&RIGHT(A1,1)&0

so if it's always 3rd character is a "/" and 6th character is a "-" etc. then this works.

Otherwise, you can do a fairly complex breakdown of the cell using the Left, Mid, and Right functions in conjunction with the Find function.

Another option might be to do a Replace using Ctrl-H on your keyboard and replacing all "-" and "/" with nothing.

It all depends on your needs. One could create a macro or a user defined function as well.