Excell Help with formating an address fild in merged cells?

Question

I am trying to create an address field in Excell and I have Merged a group of cells to place the address in, this field will be exprted to an Access Database (I do not need seperate fields for each line). The problem i am having is that the merged cell does not allow me to hit enter and drop down a line to continue adding the address i.e.
Line 1) Contracting Office
Line 2) Client Name
Line 3) address
Line 4) CITy Stae Zip

I have configured the Merged Cells for Text Wrapping and when i hit enter i jumps to another cell instead if droping to the next line. Can anyone help with this?
Thanks! Dave

Answer 1

Alt+Enter takes you down a line, but not down a cell - so I think that will give you what you are looking for.

Answer 2

properly you should merge one greater yet recording it as a macro as you do it so which you pick basically run the macro. yet once you spotlight the two cells and then merge, in lots of cases you lose some archives, so am intrigued as to the variety you're doing it. the perfect way nonetheless, in case you're utilising this spreadsheet as a database could be to maintain the names in separate cells yet according to risk to apply a concatenate function so as that they print out as though in one cellular. So in case you have first call in A1, 2d call in B1 the function could be =CONCATENATE(A1, " ", B1). The costs are crucial because of the fact as you probable be conscious of that provides you with the gap between the two cells. so which you should try this function interior the 1st row in yet another column, autofill it down and then in case you needed, cover the 1st 2 columns with the names one at a time.

Answer 3

I would just put each line in it's own cell.