Say you have your numbers in Col A, starting in Row 2, with no blank rows in
you data range. Insert a new Column B. Type the following formula in B2:
="Part # "&A2
Move your cursor to the right lower corner of B2, double click your mouse to
copy down to the last row. Press <Ctrl<C, go to Cell A2, right click and
select Paste Special. Select Values and OK out. Delete Column B and you're
done

"Parasyke" wrote:

Does anyone know how to change a section of a column of cells with this
scenario?:
I have about 3500 rows in this column with this as part of the present
values(all are text, not numeric):

103 which I want changed to: Part # 103
104 which I want changed to: Part # 104
105 which I want changed to: Part # 105
106 which I want changed to: Part # 106
107 which I want changed to: Part # 107
108 which I want changed to: Part # 108
109 which I want changed to: Part # 109
110 which I want changed to: Part # 110
111 which I want changed to: Part # 111
112 which I want changed to: Part # 112
etc.
Needles to say I don't want to do this manually!

Thanks for anyone's help! Dav