Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I'm using the join function but want to trail off the final dash at the end if nothing is entered into a column
Solved by F. S. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 18/11/2017 - 12:49
Welcome to excel got it pro
Excelchat Expert 18/11/2017 - 12:50
I understand you want to join texts from two or more cells into one cell, right?
User 18/11/2017 - 12:50
Yep basically, I've gotten that part done
User 18/11/2017 - 12:50
but there is a trailing dash
Excelchat Expert 18/11/2017 - 12:50
Can you please tell me more about it?
User 18/11/2017 - 12:50
on cells where it is empty
User 18/11/2017 - 12:51
I'm just trying to get the formulas to reference
Excelchat Expert 18/11/2017 - 12:51
okay, tell me where it is.
User 18/11/2017 - 12:51
U
User 18/11/2017 - 12:51
column U
Excelchat Expert 18/11/2017 - 12:52
okay. so you want to join H, J, L N P R and T in that order with a dash between them right?
User 18/11/2017 - 12:53
Ok
User 18/11/2017 - 12:53
so see S7
User 18/11/2017 - 12:53
there is nothing there
User 18/11/2017 - 12:53
at the end of U7
User 18/11/2017 - 12:53
there is a trailing dash though
Excelchat Expert 18/11/2017 - 12:53
hmm
Excelchat Expert 18/11/2017 - 12:54
I see trailing dashes in each cells
User 18/11/2017 - 12:54
correct
User 18/11/2017 - 12:54
I only want them, if there is a value present
Excelchat Expert 18/11/2017 - 12:55
okay, there's another way to join texts by using "&" operator
User 18/11/2017 - 12:55
ah ok
Excelchat Expert 18/11/2017 - 12:55
let me show you.
User 18/11/2017 - 12:55
wasn't sure if there was an easier way but thats fine
User 18/11/2017 - 12:55
I can do that way
User 18/11/2017 - 12:55
I just like the join function because it is simpler!
User 18/11/2017 - 12:55
thanks
Excelchat Expert 18/11/2017 - 12:56
its easier , but join function has its own limitations
Excelchat Expert 18/11/2017 - 12:56
look at column V
Excelchat Expert 18/11/2017 - 12:57
I have just used two functions
Excelchat Expert 18/11/2017 - 12:57
sorry cells
Excelchat Expert 18/11/2017 - 12:57
now I will filter out dashed if its the last entry
Excelchat Expert 18/11/2017 - 12:59
now our T2 can be empty and in that case we will get a - at the end
Excelchat Expert 18/11/2017 - 01:01
=H2&"-"&J2&if(T2="","","-")&T2
Excelchat Expert 18/11/2017 - 01:03
see the formula? when we wanna put a dash we would check whether the next cell is empty or not, if empty then put nothing otherwise put a dash.
Excelchat Expert 18/11/2017 - 01:03
we do this for all the cells that we wanna join.
Excelchat Expert 18/11/2017 - 01:03
so let me write the whole formula that you would need
Excelchat Expert 18/11/2017 - 01:06
=H2&if(J2="","","-")&J2&if(L2="","","-")&L2&if(N2="","","-")&N2&if(P2="","","-")&P2&if(R2="","","-")&R2&if(T2="","","-")&T2
Excelchat Expert 18/11/2017 - 01:06
Here you go
Excelchat Expert 18/11/2017 - 01:06
are you there?
Excelchat Expert 18/11/2017 - 01:07
Well Please check the solution when you are back
Excelchat Expert 18/11/2017 - 01:08
Please re post again if you need more help
Excelchat Expert 18/11/2017 - 01:08
Thank you and Have a great day.

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.