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

[: 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 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...

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

 

[Ken Wright]

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

Change the - to whatever you want.

You can also insert text in the same way

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

 

[: VB :]

Thanks Ken,

Your solution works brilliantly....

Thanks for your help...

Regards,

Alex