How do I automatically add a prefix to cell value in Excel?

  • Thread starter Thread starter KimG
  • Start date Start date
K

KimG

If I have a list in which the first characters repeat, (i.e. CDAxxxx), how do
I make it so that I only have to type the xxxx and the CDA is automatically
prepended?
 
You could use a helper column, for example:

In cell A1, type "xxxx"

In cell B1, put formula

="CDA"&A1


HTH,
JP
 
You must log in or register to reply here.

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

Separating prefixes in names 1
CSV->Excel Data Problem 1
Prefix in every cell 4
convert phone number 4
Regular expression search/replace in Excel 15
Autofill alphanumeric prefix in Excel 2
how to display zero prefixes in worksheet cells such as phone numb 1
How/can I automatically prefix what is already typed in a cell? 1

Back
Top