concatonation formula

R

Rekoj

Chris,

I'm not sure why the wizard is picking it up differently,
but when combining fields, I usually don't use the
Concatenate function. I use the Ampersand.

Here is an example:
=A1&"-"&B1&"-"&C1&"-"&D1&"-"&E1

Hope that helps.

Rekoj
 

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

COMPARING TIMES AND DISPLAYING TEXT USING IF CONDITION 3
Conditional Formatting Formula 3
split range address into individual cell addresses 9
Merging cells and formats 8
Baffeling IF statement 7
problem with time subtraction 7
Different Functions in One Cell Cancel Each Other Out - How can I fix this? 1
Combining several cells into single equasion? 1

Top