Do I need a IF statement??

[GRAY1026]

Please take a look at the column I highlighted in orange.

In Column S cell 3 I have concatenated the cells that I need to be in that column. However, for example if there was no data in columns W-AE how can I write my formula so it only pulls the columns that have a data entered in them.

I work in Supply chain and in order to upload items into our system I need to tell the system the unit of Measures that we can purchase for a item. This line "| " must separate each UOM.
EA-Each
BX-Box
CS-CS
So some items may only have 1 purchase unit of measure or 2 UOMs so I would leave the rest of the columns blanks. Im assuming an If statement would work here but I do no know how to write it.

Can you help?

 

[GRAY1026]

I also forgot to Mention I cannot have the "|" sitting there when there is no data listed.

 

[Fluff]

Hi & welcome to MrExcel.
How about

=TEXTJOIN("|",,T3&V3,W3&Y3,Z3&AB3,AC3&AE3)

 

[GRAY1026]

I am getting #NAME...Is there anything Im missing?

 

[Fluff]

What version of Excel are you using? Your profile shows 365

 

[GRAY1026]

 

[Fluff]

That's 2016 not 365, I would suggest that you change your profile.
As 2016 does not have textjoin, try

=MID(IF(T3<>"","|"&T3&V3,"")&IF(W3<>"","|"&W3&Y3),2,99)

 

[GRAY1026]

ok Thank you. Sorry I had initially thought it was 365 when I signed up. I got the formula to work but now I am getting FALSE if there is no data in the other columns. I dont want any data to return if there is nothing. I just need to make sure I have "|" at the end.

 

[Fluff]

What is the formula that you are using?
Also in future rather than posting images, it's better to post actual data to the site.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[GRAY1026]

I apologize. I am using a Company owned laptop and I do not see that option to add the Add in. This is the formula I am using below. Is there another way I can get the file to you?