merge cells in Excel??

[Amit]

Hi,

I have a strange problem/request regarding merging text in
Excel.

The Excel worksheet has columns for entering text data,
but whoever entered the data, continued the sentence on
the next row, as the column width is fixed, and s/he was
not aware of wrap-text property to keep the entire text in
one cell.

So, now a single text sentence is broken across multiple
cells, and the requirement is to consolidate/merge the
sentence into a single cell.

One (tedious) way is to copy-and-paste the spreadsheet
into a Word doc, and then merge cells.

I was wondering if there is any other way
simpler/faster/easier than the above to solve this
problem. I'm familiar with VB, but have only written code
for Access, not Excel/Word. So, if you have any
ideas/pointers, please let me know.

Thanks!

-Amit

 

[Charles]

Amit,

Select the cells that the text is in and then click the Format on th
toolbar and select Cells Alignment MergeCells.


HTH

Charle

 

[JE McGimpsey]

Take a look here:

http://www.mcgimpsey.com/excel/mergedata.html#mergeselection

 

[Don Guillett]

Use this instead.

Sub CenterAcross()
Selection.HorizontalAlignment = xlCenterAcrossSelection
End Sub

 

[Amit]

Yes, this is exactly what I was looking for.
Thanks for your response.

-Amit