Excel Combo Formula?

[RayHanz14]

What formula can I use to combine the elements of a data range into a single cell output?

I'm trying to automate creating sub id's based on a few different variables.

I need to use alphanumeric characters as well.

I just used the "z's" to make it slightly easier to read

Example:


Image Name- Image Name ID #- Headline #- Body Text # - Sex- Age Range- Landing Page ID #- = Sub Id Ouput

Lohan1- Z -1- Z- 2- Z- 3- Z- M- Z- 1821- Z- 1= [FONT=Bitstream Vera Sans Mono,Cumberland]Lohan1Z1Z2Z3ZMZ1821Z1

- Ray
[/FONT]

 

[jryan21]

In excel, treat all the cells used as strings (format cells -> text) and use Concatenate(C1,C2)

 

[RayHanz14]

In excel, treat all the cells used as strings (format cells -> text) and use Concatenate(C1,C2)

Thanks... That did the trick.

- Ray