ADD PREFIX TO COLUMNS

L

L. Howard Kittle

Hi Kim,

="the prefix" & a1 pull down..then copy > paste special > values to get
rid of the formulas.

="the prefix" & " " & a1 if you want a space between the prefix and #'s.

HTH
Regards,
Howard
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autofill alphanumeric prefix in Excel 2
deleting numbers prefix 3
adding a text prefix to an entire column 2
how do i add same prefix any text or number to the large datas? 1
How can I find items that have a certain prefix and define? 3
insert 780 into phone list XL workbook 1
Adding a pre-fix to each item in a cell 1
How to add a prefix to a column of numbers in an excel document? 4

Top