Hello
I have a question regarding a formula needed
I have a list of individual part numbers and i want to add some refernce letters without manually doing this for every part
eg
I have - 1234
I want - 1234-ABC
Thank you
Hi Fav,
If you have part numbers in A1:A20, then in B1 type the formula:
=A1&"-ABC"
Fill that down to B20. You can then copy B1:B20 and use PasteSpecial > Values on top of itself to remove the formulas, then delete A1:A20.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks