View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default to combine wordings in two columns

In C1: =A1&B1
Copy down
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"vcff" wrote:
Hi All

I need to combine the wordings in two columns into one under the third column

e.g.

col A col B col C
1 AM/ S3 AM/S3
2 PLA- 25 PLA-25
3 MA- SS46 MA-SS46
4 PART 38 PART38
5 AL/YU 9S1 AL/YU9S1
.....
....
...
..

Column C is the final result.

Tnks