Software602 Home . products . download . support . register . how to buy . . view cart . . . contact us . . . .
Software602 Home . . . . . .
. .
.
.
Software602 Login
E-mail:
Password:
forgot?
.
Support Home .
.
User Forum .
.
Knowledge Base .
.
Submit Ticket .
.
View My Tickets .
.
. .
.
602PC SUITE 4.2 User Forumforum home | rss | search | terms of use
BackBack to 602PC SUITE 4.2 Forum
Add New TopicAdd New Topic
Post ReplyPost Reply
combining columns
  Posted by  Alma Lorete  on Tuesday, November 01, 2005 at 9:06:22 AM (EST)
I have a spreadsheet inventory where I need to combine or merge 3 columns into 1. How do I do that?
  Posted by Paul Miller  on Tuesday, November 01, 2005 at 11:00:47 AM (EST)
Hi there,
You could use the Concatenate Function to do this:

e.g. if you have the words:
COLUMN1 in C2, and COLUMN2 in D2, and COLUMN3 in E2, the following formula would concatenate them:
=Concatenate(C2,D2,E2)

If you want spaces between each column to be concatenated:
=Concatenate(C2," ",D2," ",E2)

If you then need the concatenated data as text in your workbook, you can Copy the concatenated data, and then select Paste Special. In the Paste Special dialog, just select "Values and Results" and uncheck the "Formats" and "Comments" boxes. This will paste the data as text.

Hope this helps you,
Paul
  Posted by Alma Lorete  on Tuesday, November 08, 2005 at 1:27:29 AM (EST)
Reply is very quick. Thank you.
But sir, would you explain to me how to merge 3 columns with 1500 rows each. My column attributes are as follows: Brand,Item Title,Model No.
I appreciate the help.
BackBack to 602PC SUITE 4.2 Forum
Add New TopicAdd New Topic
Post ReplyPost Reply
.
. . .
.
  © 2009 Software602, Inc. All rights reserved.