Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Using a formula to wrap text
I am using Excel 2000
I have a worksheet which is in effect an index containing a reference number and an address. the addresses were typed in, one cell per address, using ALT+ENTER at the end of each line laying it out like an address label. The cells are formatted a wrapped text. I am now able to make use of a linked spreadsheet from an Access database maintained elsewhere and more importantly always up to date. However, each line of the address is in a different column, 6 in all, and also the managers name, which is a bonus. I can use CONCATENATE to bring all the columns into one column but this produces the managers name and the address as one long line. I tried entering (CHAR(10)) between the column references but this did not work eg =(A1&(CHAR(10))&B1). I did think of using Word but I am not doing a mailmerge and other parts of my main worksheet have some complex calculations which I do not think Word could cope with. QUESTION: Is there a way, which I can enter as a formula, which would bring all the fields together, starting each field on a new line. Thank you in advance for your help Sean Bishop |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I am using wrap text in excel, so why isn't all my text wrapping? | Excel Discussion (Misc queries) | |||
Text disappears when word wrap is used | Excel Discussion (Misc queries) | |||
Wrap Text | Excel Discussion (Misc queries) | |||
Wrap text | Excel Discussion (Misc queries) | |||
Concatenation formula loses text wrap formatting | Excel Discussion (Misc queries) |