tenneps199
New Member
- Joined
- Jul 18, 2006
- Messages
- 12
All,
I am considered my company's Excel and Access expert, but this problem has me stumped. I have 2 columns of data, as below:
Show Name Suffix
american idol
america's best dance crew series
america's got talent show
america's prom queen shows
bolt television
dance fever television series
dance war television show
dancelife television shows
Note: Cell A2 is blank intentionally.
The intent is to concatenate each of the show names (column A) with each of the suffixes. Thus, the resulting formula would provide the following:
Result
american idol
american idol series
american idol show
american idol shows
etc.
america's best dance crew
america's best dance crew series
america's best dance crew show
and so on.
This can be done quickly in Access, but we only have a few users that know anything about access. Thus, can this concatenation of multiple ranges be handled with VB scripting? If so, can anyone provide some guidance on how to write such a script?
Thanks in advance for your help.
MD
I am considered my company's Excel and Access expert, but this problem has me stumped. I have 2 columns of data, as below:
Show Name Suffix
american idol
america's best dance crew series
america's got talent show
america's prom queen shows
bolt television
dance fever television series
dance war television show
dancelife television shows
Note: Cell A2 is blank intentionally.
The intent is to concatenate each of the show names (column A) with each of the suffixes. Thus, the resulting formula would provide the following:
Result
american idol
american idol series
american idol show
american idol shows
etc.
america's best dance crew
america's best dance crew series
america's best dance crew show
and so on.
This can be done quickly in Access, but we only have a few users that know anything about access. Thus, can this concatenation of multiple ranges be handled with VB scripting? If so, can anyone provide some guidance on how to write such a script?
Thanks in advance for your help.
MD