Ask Experts Questions for FREE Help !
Ask
    dplatt1986's Avatar
    dplatt1986 Posts: 1, Reputation: 1
    New Member
    		  
    #1

    May 13, 2009, 04:18 AM
    Excel issue
    hi,

    I have a similar question.

    I have concatenated several lines of text, but I want to make it neater by entering a line break in between certain lines.

    I currently have 3 cells with the text and between them I want a line break. I need to keep the concatenate formula I'm using because it will change weekly.

    I have tried entering alt-enter but it doesn't alter the text- is there anyway I can concatenate a ^p into the formula?

    Currently is Text1, Text2, Text3

    I want it to be:
    text 1
    text 2
    text 3

    As the size of text differs I am unable to wrap text and format the width of column and do it manually.

    Any help much appreciated.
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #2

    May 13, 2009, 10:53 PM

    You shouldn't post questions of your own in someone else's thread. This isn't as related as it appears.

    Anyway, format the cell to allow WRAP TEXT, then use a formula like this to force line feeds:

    =A1&CHAR(10)&B1&CHAR(10)&C1
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #3

    May 27, 2009, 09:19 AM

    Please present the formula from that collection you are advertising that directly relates to this question.

    If one does not exist, this is spamming. Cut it out.
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Excel 15 digit issue, tried converting to text, text to column feature negates fix [ 6 Answers ]

I have the following numbers that exceed 15 characters that needs to be split into its own columns. Down the road, there would be thousands of such rows of data with the first couple set of unique numbers. 890432453253208820,5004500558,05CC,1,0,0,0,0,0,0, 0000,5.0000,2007-01-11...

Sorting issue in Excel [ 1 Answers ]

Hello - I've been working with an Excel Spreadsheet and I have run into a problem with it. I have a filter set up and I when I want to filter on a specific thing like "blanks" or "non-blanks", at the lower left hand corner of the screen it will tell me the count: "5 of 25 records found." For...

Excel 2007 to have excel 2003 look? [ 6 Answers ]

Hey I have Microsoft Excel 2007, from my course at college I have been given instructions to do a task. However these instructions are for excel 2003. How do I change my excel 07 to look like excel 03 so that it is easier. I know there is a way, help greatly appreicated thanks.

Excel 2003 Issue [ 1 Answers ]

My company recently updated the Office package from 2000 to 2003. A spreadsheet I have worked fine in 2000 , but now will not work. I received a message that Excel detected errors and repairs were made. It also states that I lost Visual Basic Project and ActiveX Controls. After the...

Excel 2003 issue [ 2 Answers ]

Hi I have a problem with the auto calculation feature in excel. It doesn't seem to be working. I have to use the super calculation feature, crtl+F9 or F9 in order for the calculation to work. Do you know why this is? I'm running excel 2003 (Office 2003 SP1) and the file was saved in excel XP....

View more questions Search