View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Andrea Andrea is offline
external usenet poster
 
Posts: 112
Default combine text from two columns to one

I would like to combine text from Column A and Column B to appear as it would
in column C. My columns appear as follows:

A B
C

Bazooka BAZ12113
BazookaBAZ12113
JVC JVC23998
JVCJVC23998
Metra MTA23990
MetraMTA23990

.......and so on. I am not sure how to combine this text; excel seems to
want to apply some mathematical formula. My columns are up to several
thousand cells long in range. Is there any easy way to do this? There HAS to
be!! Please help!! :o
--
Andrea