LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Combine Text from 2 columns into 1 dscmm Excel Discussion (Misc queries) 3 March 25th 08 08:34 PM
combine two text columns ferde Excel Discussion (Misc queries) 1 May 10th 07 01:13 AM
Combine multiple columns into two long columns, Repeating rows in first column [email protected] Excel Discussion (Misc queries) 2 July 31st 06 09:45 PM
Combine multiple columns into two long columns, Repeating rows in first column [email protected] Excel Discussion (Misc queries) 0 July 31st 06 05:07 PM
How do I combine two columns of text to 1 as in 1st name surname McGreal55 Excel Discussion (Misc queries) 2 May 19th 06 12:18 PM


All times are GMT +1. The time now is 10:59 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"