Using <BR> In A Excel Formula

[gaspower]

Hello,

I was wondering if it is possible to use <BR> in a Excel cell formula. I am using Ebay File Exchange to upload large data. The issue is File Exchange does not allow for line break or carriage return in my description field. What I have currently is,

cell B2 contains (A102)
cell C2 contains (This is a part item)

="Part Number: "&B2&C2

Which outputs -> Part Number: A102 This is a part item.

I need it to output:

Part Number: A102

This is a part item.


Thanks Jr

[shg]

How is this different from the question asked and answered at http://www.mrexcel.com/forum/showthread.php?t=584282?

[gaspower]

Hello,

I do believe CHAR(10) is a carriage return. For some reason the File Manager from Ebay does not allow carriage returns.

Thanks JR

[shg]

It's a line feed.

I can't tell from your question what you want to do.

[gaspower]

Hello,

The Ebay File upload manager will strip all carriage and line feeds. I need to be able to break a line such as <BR> in a a cel formula kile this,

="Part Number: "&B2<BR>&C2


cell B2 contains (A102)
cell C2 contains (This is a part item)

Which outputs ->
Part Number: A102
This is a part item.

JR

[shg]

I don't know what you mean by <BR>

If you mean that literal text, then

="Part Number: " & B2 & "<BR>" & C2

The only way you're going to see it in two lines in a single cell is to use a line feed.

[Leith Ross]

@SHG

<BR> is an HTML code that defines a single line break.

[shg]

Ah -- then all he needs is the literal text?

[Leith Ross]

@SHG

After looking at the other post, I am confused since the solution given was said to work. Not sure how the OP would implement an HTML solution for an Excel sheet.

[shg]

Nary a clue, Leith.

[mikerickson]

If we are guessing perhaps "<BR> puts the following text in the cell below"?

[shg]

Nary a clue, Mike.