Adding to a list

  • Thread starter Thread starter rpick60
  • Start date Start date
R

rpick60

I looking for a way to add characters to a cell that is part of a
list. I have created a list that has several common names and then I
want to be able to add charachters to the end of the name

Slide (is in the list)
Slide 1
Slide 2
Slide 3

Core 1
Core 2
Core 3

Can I just have slide in my list and then add the number?
50% of my name sin the list can end up having numbers from 1-30 after
it.
I do not want to have a pull down that is a mile long.
Any Idea?
 
When you say a 'pull down', do you mean data validation with a list? If you
do then you could have a data validation list with Slide, Core etc in cell
A1. In cell B1 a data validation list of 1 to 30 and then in C1 the following
formula:-

=A1&B1

This concatenates the two values. assuming Slide was selected for A1 and 4
was selected for B1 then the result would be Slide4.
 
Back
Top