Merging 3 Columns in an Excel Spreadsheet (Keeping Data Intact)...?

[: VB :]

Hello all,

I have a question regarding Excel 2000 (from Office Pro) and the use of
Macros. Essentially, i have a spreadsheet containing 20,000 records and i
have 3 columns that should be one - the data that was supposed to be in one
column has ended up split over 3 columns and i desperately need to fix this
but am lost as to how to go about it...?

I have created the following Macro which copies the contents of the 2nd and
3rd column into the 1st column but this only works for the first record -
would it be possible to make this automatically continue until there is no
more data to process...?

Sub Ma_Merge3Columns()
Range("N1").Select
ActiveCell.FormulaR1C1 = "Text Content"
Range("M1").Select
ActiveCell.FormulaR1C1 = "Text Content"
Range("O1").Select
ActiveCell.FormulaR1C1 = ""
Range("M1").Select
ActiveCell.FormulaR1C1 = "Text Content"
Range("M1").Select
End Sub

I would appreciate any advice on this matter...

Thanks in advance...

Regards,

Alex

 

[: VB :]

Hello,

Firstly, thanks to Dick Kusleika for replying to my original post regarding
how to merge 3 columns in my Excel 2000 spreadsheet. I have a another query
related to this that i'm now stuck on...

I have realised that as well as merging the 3 columns of data, i need to
force some kind of hypen or "seperator" in there so that when the 3 columns
of data are merged, the data isnt stuck together making it difficult to
understand...

This method works GREAT and i have now only to force a "seperator" into the
equation so that when each column is merged, they are seperated by a hypen
or something similar...

I wont be needing to do this "merging" of columns on a regular basis so i
dont mind sticking with the above equation as long as it can also, force a
"seperator"...

Could you let me know how i would go about trying to achieve this
successfully?

Many, many thanks for pointing me in the right direction - i hope that this
additional request is "doable" and that you can let me know either
way...(maybe i need to use a macro if the above isnt possible with a
formula)...?

Best Regards,

Alex

 

[Ken]

It's much the same:

=A1&"-"&B1&"-"&C1

Hello,

Firstly, thanks to Dick Kusleika for replying to my original post regarding
how to merge 3 columns in my Excel 2000 spreadsheet. I have a another query
related to this that i'm now stuck on...

I have realised that as well as merging the 3 columns of data, i need to
force some kind of hypen or "seperator" in there so that when the 3 columns
of data are merged, the data isnt stuck together making it difficult to
understand...


This method works GREAT and i have now only to force a "seperator" into the
equation so that when each column is merged, they are seperated by a hypen
or something similar...

I wont be needing to do this "merging" of columns on a regular basis so i
dont mind sticking with the above equation as long as it can also, force a
"seperator"...

Could you let me know how i would go about trying to achieve this
successfully?

Many, many thanks for pointing me in the right direction - i hope that this
additional request is "doable" and that you can let me know either
way...(maybe i need to use a macro if the above isnt possible with a
formula)...?

Best Regards,

Alex