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?
|