Table Header Name with carriage return

[sspatriots]

I'm hoping this is an easy fix, but can't seem to get there.

I have the following line of code:

=IF(ISBLANK(XLOOKUP([@[Cab
PO]],'PO Block History - DEM.xlsm'!Table7[COMPL PO NO CORR],'PO Block History - DEM.xlsm'!Table7[Date Received:])),"",

How can I get this all on one line without causing an error message. The reason it sows "Cab PO" jumping to the next line is because the header name has a hard return that puts it on the next line. I tried to use:

"Cab" & CHAR(10) & "PO"

However, that did not work. Thanks in advance for any assistance on this.

 

[6StringJazzer]

If the heading has a return, the formula is going to show the return.

If you want the formula to fit on one line, remove the return from the heading and then use Word Wrap if you want it to wrap to two lines.

 

[sspatriots]

If the heading has a return, the formula is going to show the return.

If you want the formula to fit on one line, remove the return from the heading and then use Word Wrap if you want it to wrap to two lines.

Thanks, I just left it in there. I was trying to clean it up. If I use the wrap feature, some of the headers look strange because of the point at which the wrap around to the next row.

 

[6StringJazzer]

Another option would be to use standard range references in the formula instead of structured table references, but the structured references have other benefits. Is this formula in the table, or outside of it?

 

[sspatriots]

Another option would be to use standard range references in the formula instead of structured table references, but the structured references have other benefits. Is this formula in the table, or outside of it?

Inside the table. This table is very dynamic in that someone always wants to insert a column or delete one or add some to the end. That's why I went with the structured references.

 

[6StringJazzer]

Well, that is definitely the benefit of structured references. Unfortunately I don't have a solves-it-all option for you.