BleepingComputer.com: Excel References

I am trying to create a field that is comprised of other fields. For example:

I want my A1 column text to be information from column B1, C1, and D1. So a formula would look like =A1-B1-D1 but obviously this will subtract tbe three cells from each other. I want it to look like Dog-Cat-Fish.

I hope I am explaining this well enough. I appreciate any help offered. Im not even sure if this is possible in excel though.

-Steve

Text does not work in the same way as numeric data, which seems to be what you want to accomplish; do I understand that you want words to subtract from themselves, or do you simply want to place (in your example) three words each from a different column, separated by a dash, in another column?
Cheers,
John

Like my example, I want column A1 to have three words separated by dashes from three other columns. However, A2 could be different because B2 is different from B1.

Sorry, a little tough to explain in writing. Thanks for the quick reply.

You do not want arithmetic operations, right?
You want words to be concatenated, but with dashes in between the words, and furthermore, you don't care if the length of those strings is unequal. If this is what you mean, just type this:
=B1 & "-" & C1 & "-" & D1

Regarding your "So a formula would look like =A1-B1-D1 but obviously this will subtract tbe three cells from each other"
Sorry, that's impossible! It will subtract B1 and D1 from A1 so long as those cells are numbers and not text

That is exactly what I needed. Thanks man, you just saved me a lot of time.