On Thursday, July 17, 2008 7:32:03 PM UTC+2, J Sedoff wrote:
Do you mean you have a letter/symbol at the beginning of your text that you
wish to switch out with a new letter?

Like this:
"a100" -- "b100"

Then just use the formula =CONCATENATE("b", RIGHT(A2,LEN(A2)-1))
The Concatenate will allow you to add anything (replace the "b" with
whatever the new prefix code is) and the Right(A2,Len(A2)-1) will remove the
first symbol.

Initially you will have to put this in another column/row, but then you can
just copy and paste Special Values (right-click, "Paste Special," choose
"Values" then ok) into the old field and delete the new column (or you may
want to keep the old column as is in case you have stragglers using the old
system... I don't know).

Hope this helps, Jim

"Beth" wrote:

Our company is altering the code of our item numbers. is there a way to
delete one letter from a line of symbols and add a prefix to the front at the
same time?

J Sedoff you a genius!!!!!