Merging 3 Columns in an Excel Spreadsheet (Keeping Data Intact)...2nd Post
 

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 hyphen or "separator" in there so that when the 3 columns
of data are merged, the data isn't stuck together making it difficult to
understand...

You can modify that macro to do what you want, but first you should decide
if a macro is appropriate. If you have to do this operation all the time,
then a macro would be great. If you just need to do it once, then I would
use formulas. Namely, in an unused column put this formula
=A1&B1&C1
then fill down 20,000 rows. Copy that column and Paste Special - Values
over column A. Then delete the column with the formula.

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

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

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 isn't possible with a
formula)...?

Best Regards,

Alex

Merging 3 Columns in an Excel Spreadsheet (Keeping Data Intact)...2nd Post
 

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

Change the - to whatever you want.

You can also insert text in the same way

=A1&"- Pounds"&B1&"- Pence"&C1&" Today"

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL2K & XLXP

----------------------------------------------------------------------------
Attitude - A little thing that makes a BIG difference
----------------------------------------------------------------------------



": VB :" wrote in message ...
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 hyphen or "separator" in there so that when the 3 columns
of data are merged, the data isn't stuck together making it difficult to
understand...

You can modify that macro to do what you want, but first you should decide
if a macro is appropriate. If you have to do this operation all the time,
then a macro would be great. If you just need to do it once, then I would
use formulas. Namely, in an unused column put this formula
=A1&B1&C1
then fill down 20,000 rows. Copy that column and Paste Special - Values
over column A. Then delete the column with the formula.

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

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

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 isn't possible with a
formula)...?

Best Regards,

Alex

Merging 3 Columns in an Excel Spreadsheet (Keeping Data Intact)...2nd Post
 

Thanks Ken,

Your solution works brilliantly....

Thanks for your help...

Regards,

Alex


"Ken Wright" wrote in message
...
=A1&"-"&B1&"-"&C1

Change the - to whatever you want.

You can also insert text in the same way

=A1&"- Pounds"&B1&"- Pence"&C1&" Today"

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL2K & XLXP

--------------------------------------------------------------------------
--
Attitude - A little thing that makes a BIG difference
--------------------------------------------------------------------------
--



": VB :" wrote in message
...
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 hyphen or "separator" in there so that when the 3
columns
of data are merged, the data isn't stuck together making it difficult to
understand...

You can modify that macro to do what you want, but first you should
decide
if a macro is appropriate. If you have to do this operation all the
time,
then a macro would be great. If you just need to do it once, then I
would
use formulas. Namely, in an unused column put this formula
=A1&B1&C1
then fill down 20,000 rows. Copy that column and Paste Special -
Values
over column A. Then delete the column with the formula.

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

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

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 isn't possible with a
formula)...?

Best Regards,

Alex