A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Merging Columns



 
 
Thread Tools Display Modes
  #1  
Old July 29th, 2007, 04:06 PM posted to microsoft.public.excel.worksheet.functions
Titanium
external usenet poster
 
Posts: 47
Default Merging Columns

I am trying to 'make one' a number of columns...
Essentially I have several thousand rows of data that I need to clean up...
What I would like to accomplish is Column A + B = AB

Column A Data: I need this one first
Column B Data: and this one comes right behind with a space for proper grammer
To equal one column: I need this one first and this one comes right behind
with a space for proper grammer.

Thanks in advance for any input!

Ti




  #2  
Old July 29th, 2007, 04:35 PM posted to microsoft.public.excel.worksheet.functions
Roger Govier[_2_]
external usenet poster
 
Posts: 55
Default Merging Columns

Hi

In C1
=A1&" "&B1
Copy down as far as required.
Copy column CPastes Special back over the formulae to "fix" the values.

--
Regards
Roger Govier



"Titanium" wrote in message
...
I am trying to 'make one' a number of columns...
Essentially I have several thousand rows of data that I need to clean
up...
What I would like to accomplish is Column A + B = AB

Column A Data: I need this one first
Column B Data: and this one comes right behind with a space for proper
grammer
To equal one column: I need this one first and this one comes right behind
with a space for proper grammer.

Thanks in advance for any input!

Ti






  #3  
Old July 29th, 2007, 04:39 PM posted to microsoft.public.excel.worksheet.functions
Gord Dibben
external usenet poster
 
Posts: 20,252
Default Merging Columns

In C1 enter =A1 & " " & B1

Double-click on fill handle of C1 to copy down.


Gord Dibben MS Excel MVP

On Sun, 29 Jul 2007 08:06:02 -0700, Titanium
wrote:

I am trying to 'make one' a number of columns...
Essentially I have several thousand rows of data that I need to clean up...
What I would like to accomplish is Column A + B = AB

Column A Data: I need this one first
Column B Data: and this one comes right behind with a space for proper grammer
To equal one column: I need this one first and this one comes right behind
with a space for proper grammer.

Thanks in advance for any input!

Ti




  #4  
Old July 29th, 2007, 04:56 PM posted to microsoft.public.excel.worksheet.functions
Titanium
external usenet poster
 
Posts: 47
Default Merging Columns

This formula does work. However, it uses up two rows...

It merges 1/2 the data appropriately, but fails to merge every other line...



"Roger Govier" wrote:

Hi

In C1
=A1&" "&B1
Copy down as far as required.
Copy column CPastes Special back over the formulae to "fix" the values.

--
Regards
Roger Govier



"Titanium" wrote in message
...
I am trying to 'make one' a number of columns...
Essentially I have several thousand rows of data that I need to clean
up...
What I would like to accomplish is Column A + B = AB

Column A Data: I need this one first
Column B Data: and this one comes right behind with a space for proper
grammer
To equal one column: I need this one first and this one comes right behind
with a space for proper grammer.

Thanks in advance for any input!

Ti







  #5  
Old July 29th, 2007, 05:10 PM posted to microsoft.public.excel.worksheet.functions
Gord Dibben
external usenet poster
 
Posts: 20,252
Default Merging Columns

How so unless your data is not as you originally described it?

A1 = first
B1 = last

A2 = next first
B2 = next last

In C1 using the formula given you will get "first last"

In C2 you will get "nextfirst next last"


Gord

On Sun, 29 Jul 2007 08:56:01 -0700, Titanium
wrote:

This formula does work. However, it uses up two rows...

It merges 1/2 the data appropriately, but fails to merge every other line...



"Roger Govier" wrote:

Hi

In C1
=A1&" "&B1
Copy down as far as required.
Copy column CPastes Special back over the formulae to "fix" the values.

--
Regards
Roger Govier



"Titanium" wrote in message
...
I am trying to 'make one' a number of columns...
Essentially I have several thousand rows of data that I need to clean
up...
What I would like to accomplish is Column A + B = AB

Column A Data: I need this one first
Column B Data: and this one comes right behind with a space for proper
grammer
To equal one column: I need this one first and this one comes right behind
with a space for proper grammer.

Thanks in advance for any input!

Ti








  #6  
Old July 29th, 2007, 06:00 PM posted to microsoft.public.excel.worksheet.functions
Titanium
external usenet poster
 
Posts: 47
Default Merging Columns

Gord, I could be wrong, but I believe the reason Roger's formula didn't work
for me is because of the spacing. Your formula worked perfectly fine. I do
appreciate the help of both Roger and yourself. You saved me countless hours
of hellish copy & pasting monotony...

"Gord Dibben" wrote:

In C1 enter =A1 & " " & B1

Double-click on fill handle of C1 to copy down.


Gord Dibben MS Excel MVP

On Sun, 29 Jul 2007 08:06:02 -0700, Titanium
wrote:

I am trying to 'make one' a number of columns...
Essentially I have several thousand rows of data that I need to clean up...
What I would like to accomplish is Column A + B = AB

Column A Data: I need this one first
Column B Data: and this one comes right behind with a space for proper grammer
To equal one column: I need this one first and this one comes right behind
with a space for proper grammer.

Thanks in advance for any input!

Ti





  #7  
Old July 29th, 2007, 08:18 PM posted to microsoft.public.excel.worksheet.functions
Gord Dibben
external usenet poster
 
Posts: 20,252
Default Merging Columns

Our formulas were basically the same.

Mine had a couple of extra spaces for clarity only.

=A1 & " " & B1

Roger left them out.

=A1&" "&B1

No difference in function.


Gord

On Sun, 29 Jul 2007 10:00:01 -0700, Titanium
wrote:

Gord, I could be wrong, but I believe the reason Roger's formula didn't work
for me is because of the spacing. Your formula worked perfectly fine. I do
appreciate the help of both Roger and yourself. You saved me countless hours
of hellish copy & pasting monotony...

"Gord Dibben" wrote:

In C1 enter =A1 & " " & B1

Double-click on fill handle of C1 to copy down.


Gord Dibben MS Excel MVP

On Sun, 29 Jul 2007 08:06:02 -0700, Titanium
wrote:

I am trying to 'make one' a number of columns...
Essentially I have several thousand rows of data that I need to clean up...
What I would like to accomplish is Column A + B = AB

Column A Data: I need this one first
Column B Data: and this one comes right behind with a space for proper grammer
To equal one column: I need this one first and this one comes right behind
with a space for proper grammer.

Thanks in advance for any input!

Ti






  #8  
Old July 29th, 2007, 11:30 PM posted to microsoft.public.excel.worksheet.functions
Titanium
external usenet poster
 
Posts: 47
Default Merging Columns

Not that I'm questioning the formula, or putting Roger down...
But apparently the spaces do have some effect on the end result...

As I've said for many years computers and their functions boil down to two
things... 1's for on, true or working... and 0's for off, false and not
working...

I appreciate all the help from everyone who offered a hand...


"Gord Dibben" wrote:

Our formulas were basically the same.

Mine had a couple of extra spaces for clarity only.

=A1 & " " & B1

Roger left them out.

=A1&" "&B1

No difference in function.


Gord

On Sun, 29 Jul 2007 10:00:01 -0700, Titanium
wrote:

Gord, I could be wrong, but I believe the reason Roger's formula didn't work
for me is because of the spacing. Your formula worked perfectly fine. I do
appreciate the help of both Roger and yourself. You saved me countless hours
of hellish copy & pasting monotony...

"Gord Dibben" wrote:

In C1 enter =A1 & " " & B1

Double-click on fill handle of C1 to copy down.


Gord Dibben MS Excel MVP

On Sun, 29 Jul 2007 08:06:02 -0700, Titanium
wrote:

I am trying to 'make one' a number of columns...
Essentially I have several thousand rows of data that I need to clean up...
What I would like to accomplish is Column A + B = AB

Column A Data: I need this one first
Column B Data: and this one comes right behind with a space for proper grammer
To equal one column: I need this one first and this one comes right behind
with a space for proper grammer.

Thanks in advance for any input!

Ti







  #9  
Old July 30th, 2007, 09:12 AM posted to microsoft.public.excel.worksheet.functions
Roger Govier[_2_]
external usenet poster
 
Posts: 55
Default Merging Columns

Hi
Not that I am offended in any way, but as Gord says his formula and mine are
identical, other than the way Gord typed his for clarity.

Both will work in an identical manner - they cannot do otherwise.

--
Regards
Roger Govier



"Titanium" wrote in message
...
Not that I'm questioning the formula, or putting Roger down...
But apparently the spaces do have some effect on the end result...

As I've said for many years computers and their functions boil down to two
things... 1's for on, true or working... and 0's for off, false and not
working...

I appreciate all the help from everyone who offered a hand...


"Gord Dibben" wrote:

Our formulas were basically the same.

Mine had a couple of extra spaces for clarity only.

=A1 & " " & B1

Roger left them out.

=A1&" "&B1

No difference in function.


Gord

On Sun, 29 Jul 2007 10:00:01 -0700, Titanium
wrote:

Gord, I could be wrong, but I believe the reason Roger's formula didn't
work
for me is because of the spacing. Your formula worked perfectly fine. I
do
appreciate the help of both Roger and yourself. You saved me countless
hours
of hellish copy & pasting monotony...

"Gord Dibben" wrote:

In C1 enter =A1 & " " & B1

Double-click on fill handle of C1 to copy down.


Gord Dibben MS Excel MVP

On Sun, 29 Jul 2007 08:06:02 -0700, Titanium
wrote:

I am trying to 'make one' a number of columns...
Essentially I have several thousand rows of data that I need to clean
up...
What I would like to accomplish is Column A + B = AB

Column A Data: I need this one first
Column B Data: and this one comes right behind with a space for
proper grammer
To equal one column: I need this one first and this one comes right
behind
with a space for proper grammer.

Thanks in advance for any input!

Ti









  #10  
Old July 30th, 2007, 02:26 PM posted to microsoft.public.excel.worksheet.functions
Titanium
external usenet poster
 
Posts: 47
Default Merging Columns

I will certainly admit when I'm wrong... and I am...

I'm really baffled as to what I did... but after retesting the formula it
did work.

What orginally happened was that it merged every other row...and left one
row blank...

The results didn't make the slighest bit of sense, but I had to go with what
I saw...

Again, thanks for your help.

"Roger Govier" wrote:

Hi
Not that I am offended in any way, but as Gord says his formula and mine are
identical, other than the way Gord typed his for clarity.

Both will work in an identical manner - they cannot do otherwise.

--
Regards
Roger Govier



"Titanium" wrote in message
...
Not that I'm questioning the formula, or putting Roger down...
But apparently the spaces do have some effect on the end result...

As I've said for many years computers and their functions boil down to two
things... 1's for on, true or working... and 0's for off, false and not
working...

I appreciate all the help from everyone who offered a hand...


"Gord Dibben" wrote:

Our formulas were basically the same.

Mine had a couple of extra spaces for clarity only.

=A1 & " " & B1

Roger left them out.

=A1&" "&B1

No difference in function.


Gord

On Sun, 29 Jul 2007 10:00:01 -0700, Titanium
wrote:

Gord, I could be wrong, but I believe the reason Roger's formula didn't
work
for me is because of the spacing. Your formula worked perfectly fine. I
do
appreciate the help of both Roger and yourself. You saved me countless
hours
of hellish copy & pasting monotony...

"Gord Dibben" wrote:

In C1 enter =A1 & " " & B1

Double-click on fill handle of C1 to copy down.


Gord Dibben MS Excel MVP

On Sun, 29 Jul 2007 08:06:02 -0700, Titanium
wrote:

I am trying to 'make one' a number of columns...
Essentially I have several thousand rows of data that I need to clean
up...
What I would like to accomplish is Column A + B = AB

Column A Data: I need this one first
Column B Data: and this one comes right behind with a space for
proper grammer
To equal one column: I need this one first and this one comes right
behind
with a space for proper grammer.

Thanks in advance for any input!

Ti










 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:36 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.