ExcelBanter - Make a word out of two cells

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Make a word out of two cells (https://www.excelbanter.com/excel-discussion-misc-queries/244691-make-word-out-two-cells.html)

Wombat

Make a word out of two cells

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

Eduardo

Make a word out of two cells

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

Wombat

Make a word out of two cells

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

Eduardo

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

All times are GMT +1. The time now is 12:06 AM.