Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
How to add a prefix to a column of numbers in an excel document?
3,143 views
Skip to first unread message
Beth
Apr 18, 2008, 2:39:01 PM4/18/08
to
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?
delete one letter from a line of symbols and add a prefix to the front at the
same time?
Mike H
Apr 18, 2008, 2:58:00 PM4/18/08
to
Beth,
There are numerous ways but picking the best depends on the data layout. can
we see a sample from the column to be changed.
Mike
J Sedoff
Jul 17, 2008, 1:32:03 PM7/17/08
to
Do you mean you have a letter/symbol at the beginning of your text that you
wish to switch out with a new letter?
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
sifi...@gmail.com
Aug 24, 2012, 6:50:24 PM8/24/12
to
Don Guillett
Aug 25, 2012, 8:32:37 AM8/25/12
to
0 new messages