Trying to put a dash- in my formula to separate a number&name
 

Trying to put a dash- in my formula to separate a number&name
 

I have no idea what you mean?

http://www.cpearson.com/excel/newposte.htm


--


Regards,


Peo Sjoblom


"bearingpg" wrote in message
...

Trying to put a dash- in my formula to separate a number&name
 

The question should be in the body of your message, not in the subject line.

If you have your number in A1 and your name in B1, try =A1&"-"&B1
--
David Biddulph

"bearingpg" wrote in message
...