=B1&"-"&C1

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Saky" wrote in message
...
This seams very complex... :( I'm trying to create all by me self, so
i didn+t find that useful so far.

Can somebody tel me how to merge to numbers and place - between them?

I have a table exa.:
Manchester 3 0 Arsenal
Each data is in deferent cell. I need this to numbers to put in one
cell and put a - between them, to get 3-0. How to do it?




On Mon, 9 Oct 2006 09:21:34 +0100, "Bob Phillips"
wrote:

Take a look at http://xldynamic.com/source/xld.Leag...e.html#sansVBA