Excel Help Needed..

[mdrollas]

Greetings! Have an excel and need expertise from Anand gurus!

I have the following text in 5 different columns and I am tring to combine them while adding few more characters and things like dash and forward slash. I need to do this for a few thousand lines... so any input would be extremely helpful! Thanks!


ABC 1A YYY 1A 1A

ABC_XXX1A-YYY1A/1A

 

[jersiq]

I assume the text and/or characters you want to add are standard for the entire worksheet?

Use the CONCATENATE function, and add your info between your cells using quotes for the characters or spaces.

Using your example, in the next column for output:

=CONCATENATE(A1,"_XXX",B1,"-",C1,D1,"/",E1)
Pull the formula handle through the column to copy down.

 

[mayest]

jersiq is exactly right. However, most people don't use the Concatenate() function. It is easier to use an ampersand (&) instead:

=A1&"_XXX"&B1&"-"&C1&D1&"/"&E1

Note that if you have any numbers in your list, then you will need to use the Text() function to convert them to strings before concatenating.