Mike everyone has their own preferences, I don't like to format the data to
show "PL"+ plus the number, but to actually create a new column with the
PL012345 part number. I would enter you part numbers in column A and then in
column B enter the formula ="PL"&A1 so column B shows the alpha numeric
part number.

Also since you are entering parts with leading zeros, be sure to format
column A to Text before starting so Excel doesn't 'help' you and remove the
leading zero.


"Mike Busch" wrote:

I would like to place a prefix for suffix in every cell, either or. I need to
place a part number that starts with the same tow letters, say PL, and then I
would like to only type in the part number but have the prefix in the same
cell, exp. type in 097886 and have PL097886 appear in the cell. Is this
do-able. Thanks in advance.