Unable to wrap text into cell from another excel doc SOLVED

[ebaynut]

Please see attached photo

I am trying to return a line within a cell. The problem I'm having is I'm using information from another excel doc along with information from the current excel doc. I need the information from the other excel doc to be on the second line within the cell and information from the current doc to be on the first line. Again see picture.

I tried wrapping text and in the the display bar at the top it looks correct but still outputs to a single line. I also did ALT+Return and same issue occurs.

Ex. Currently Cell B3 shows Software - Intranet - Corporate Directory Hardware

It is suppose to say:
Software - Intranet - Corporate Directory
Hardware

Any advice is greatly appreciated. Thank you.

[Blake 7]

can u upload your sheet with what you have got and just type what you want to go and where?

[ebaynut]

Attached is the excel sheet.

Unfortunately, due to private information, I cannot attach the second excel sheet but you should be able to just make a copy of this excel sheet. The data doesn't matter, it's the equation that matters.

Thank you.

[Blake 7]

you need to be more specific. What r u expecting to go where.?

Does sheet "search by item code" have to look up the database sheet.

The more you put into the description of what u want the easier it will be for others to help you.

Please try a bit harder to decribe your requirement. as it is i dont understand

[ebaynut]

Yes the search by item code is searching to the database tab. The search is irrelevant at this time.

I'm concerned with the database tab. I need to have information in the same row from cells 'C3' 'D3' and 'E3' to appear in 'B3'. As well, I need to have information from another excel document inserted on the second line of the same cell of B3. I know that's a lot but it has to be a specific format. Here's an Example:

| B3 | C3 | D3 | E3
| 1Z! | 1 | Z | !
(Information
from
another
excel Doc)
_______________________________________________

I hope that was clear enough. Please let me know if you have any other questions.

Thank you in advance.

[Blake 7]

Hi there - finally i understand what you want to do - To display the text from another sheet an a secnd line within cell B3. As if pressing ALT + Enter to make a multiple line,

I tried with this formula - but to no avail. I reallly think that you will need VBA to achieve this.

Sorry - i cant be more helpful.

=C3&" - "&D3&" - "&E3&" - "&'C:\Documents and Settings\Owner\My Documents\[nyc.xlsx]Sheet1'!$A$1

[martindwilson]

=C3&" - "&D3&" - "&E3&char(10)&'C:\Documents and Settings\Owner\My Documents\[nyc.xlsx]Sheet1'!$A$1
will wrap to a new line

[Blake 7]

Hi matin - your right - hope the bejeezers did u know that!!! pls explain the role of the char 10 as im interested to know how u did it! cheers dude! i'm as excited as the op will/should be!!

[martindwilson]

char(10)= line feed or alt+enter,
i just looked it up a long time ago!

[Blake 7]

Thanks for that. i'll add it to my excel magic trick folder!

[ebaynut]

I'm very impressed! Thank you both for your help! Good work!