Home |
Search |
Today's Posts |
#1
|
|||
|
|||
excell problems
how can i put TWO LINES OF NUMBERS IN ONE CELL
|
#2
|
|||
|
|||
<Alt <Enter
-- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "THE JOKER" wrote in message ... how can i put TWO LINES OF NUMBERS IN ONE CELL |
#3
|
|||
|
|||
Hi, If you want to put two lines of data into one cell, use the concatenate function. This joins up to 30 cells of information. The easy way is: =A1&A2 The slow way is: =CONCATENATE(A1,A2) If you want to view the data on two lines in the cell, format the cells for Word Wrap (Format menu, Cells, Alignment, Wrap Text) and make the column as wide as the first word. Hope this is what you want. All the best, Roly -- roly ------------------------------------------------------------------------ roly's Profile: http://www.excelforum.com/member.php...o&userid=24631 View this thread: http://www.excelforum.com/showthread...hreadid=401724 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I view an excell document without excell (not installed wit. | Excel Discussion (Misc queries) | |||
insert query into excell sheet to update excell sheet and pivot table | Excel Discussion (Misc queries) | |||
Can I view an excell document without excell (not installed wit. | Excel Discussion (Misc queries) | |||
lable ranges in Excell | Excel Discussion (Misc queries) | |||
Why can't we see or access MS Excell 2003 even though we have MS . | Setting up and Configuration of Excel |