Opposite of Text to column
 

Ok, here is my problem

I've got 2 cells next to each other,

252 | Dairy Entertaining

is there anyway in which I can get it into one cell like:

252 - Dairy Entertaining

Bear in mind, i have heaps of cells like that, so instead of me just
cutting and copying, is there an easier way?

Opposite of Text to column
 

Use a formula like:

=a1 & " - " & b1

And drag drag down the column.

Gor_yee wrote:

Ok, here is my problem

I've got 2 cells next to each other,

252 | Dairy Entertaining

is there anyway in which I can get it into one cell like:

252 - Dairy Entertaining

Bear in mind, i have heaps of cells like that, so instead of me just
cutting and copying, is there an easier way?

--

Dave Peterson

Opposite of Text to column
 

Sure if you data is in A1 and B1 then use:

=A1 & " - " & B1

in a third cell and copy down
--
Gary's Student


"Gor_yee" wrote:

Ok, here is my problem

I've got 2 cells next to each other,

252 | Dairy Entertaining

is there anyway in which I can get it into one cell like:

252 - Dairy Entertaining

Bear in mind, i have heaps of cells like that, so instead of me just
cutting and copying, is there an easier way?

Opposite of Text to column
 

Thanks mate,

You are a legend


Gary''s Student wrote:

Sure if you data is in A1 and B1 then use:

=A1 & " - " & B1

in a third cell and copy down
--
Gary's Student


"Gor_yee" wrote:

Ok, here is my problem

I've got 2 cells next to each other,

252 | Dairy Entertaining

is there anyway in which I can get it into one cell like:

252 - Dairy Entertaining

Bear in mind, i have heaps of cells like that, so instead of me just
cutting and copying, is there an easier way?