View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Eduardo Eduardo is offline
external usenet poster
 
Posts: 2,276
Default Make a word out of two cells

your welcome, thanks for the feedback

"Wombat" wrote:

Genius. Thanks!

"Eduardo" wrote:

Hi,
use

=A1&" - "&B1


"Wombat" wrote:

I have two columns of cells: one with a 3 digit number and the other with a
name.

How do I put the two together in a column so that it looks something like
this:

"number - name"

Thanks for any help