Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Merge multiple cells
Hi,
I would like to know, how can I merge multiple cells without loosing the value and have a space between them. Example: if A1=Text1, if A2=text2, if A3=text3, if A4=text4 Then I select with my mouse A1 to A4 and I apply a merge then I get in the same cell: text1 text2 Text3 text4 Anyone know how to do such thing ? Thank you, Adi, --- Message posted from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Merge multiple cells
You could create a procedure to do it. I think the following will do what
you want Sub MergeAndCombine() Dim curCell As Object Dim strText As String For Each curCell In Selection strText = strText & curCell.Value & " " curCell.Value = "" Next ActiveCell.Value = RTrim(strText) Selection.HorizontalAlignment = xlCenter Selection.Merge End Sub Sue "gasma1975 " wrote in message ... Hi, I would like to know, how can I merge multiple cells without loosing the value and have a space between them. Example: if A1=Text1, if A2=text2, if A3=text3, if A4=text4 Then I select with my mouse A1 to A4 and I apply a merge then I get in the same cell: text1 text2 Text3 text4 Anyone know how to do such thing ? Thank you, Adi, --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Merge multiple cells
If you want to merge a lot of cells in columns on a row by row bases
see MergeRxR_Join macro in http://www.mvps.org/dmcritchie/excel/merge.htm --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
merge info from multiple cells | Excel Discussion (Misc queries) | |||
Merge multiple cells | Excel Worksheet Functions | |||
Merge Multiple Cells | Excel Discussion (Misc queries) | |||
How do I merge cells with multiple data values? | Excel Discussion (Misc queries) | |||
merge multiple row cells of text corresponding to one row of data | Excel Worksheet Functions |