View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gor_yee Gor_yee is offline
external usenet poster
 
Posts: 38
Default 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?