Hi,
depending on what sort of data you need to put in front of the numbers,
but two ways I can think of

say your data starts in A1

in column B go down and put the data in the cells where you want to add
something before the corresponding cell in column A.

so your data would look like this.

- col A ----- col B ----- col C
X39655
X39656
X39711
39662--------x
39664--------x
39665--------x


in C1 put the formula =B1&A1

you can then copy this down the column (click on the black square at
the bottom right corner of C1 and drag it down the column C.)

If you have nothing but X's to put at the start you could sort the data
numerically so that all the X numbers were at the bottom, then in B1 put
the formula ="X"&A1

again copy this down until you reach the numbers prefixed with the
"X".
(if you choose the second one befroe you start you may want to insert a
helper column with a number series in say 1-1000 so after sorting and
inserting the X's you can resort back to the original list.)

HTH.


--
greg7468


------------------------------------------------------------------------
greg7468's Profile: http://www.excelforum.com/member.php...fo&userid=9031
View this thread: http://www.excelforum.com/showthread...hreadid=379578