Log in

View Full Version : Formatting cells in excel



420
26-11-2008, 07:01 PM
I have a whole column of cells in excel with Well IDs in this format:

00031000714W400

I need to get them all in this format:

100/03-10-007-14W4/00

The #1 is added to the beginning of the UWI's.

anybody know how to change them all easily.

Rep will be awarded:help