Joining Text with Hypen

[colarguns]

I have asked this before in this forum (https://www.mrexcel.com/forum/excel-questions/1062061-separating-characters-hyphen.html#post5100161), but have ran into a hiccup.

Cell AJ2 has "Khaki" without quotes
Cell AJ3 has "Medium Gray" without quotes

In cell K2 I have (=SUBSTITUTE(AJ2&"/"&AK2, ""," ") which results in "Khaki/ Medium Gray" without quotes. Notice the space after hyphen

In cell L2 I have (=SUBSTITUTE(TRIM(SUBSTITUTE(K2,"/"," "))," ","-") which results in "Khaki-Medium-Gray" without quotes

The objective is (Khaki/Medium Gray) without parentheses. I am trying to get rid of that space. I have ensured all cells containing text do not have any other characters, and all text have been formatted to left alignment, center, right, all with no differences to results. The cells are also formatted as general.

Please note, what I have are two columns that contain colors. Not all colors will be the same. Example, I might have (Bright White) in one cell, and (Bright Purple) in another cell. All with the same objective of (Bright White/Bright Purple).

I am mentally challenged tonight, lol, so any help would be appreciated. Thank you

 

[sandy666]

You are hereby awarded the MS Excel Pulitzer Award of the Century! That worked great!!!!! Thank you so much Sandy!

LOL, thanks
You are welcome
Have a nice day

 

[colarguns]

Did you teach yourself this? Did you learn it by reading all the Walkenbach books? Impressive!

 

[sandy666]

I never read Walkenbach's books.
only practice, test, test and test again

 

[colarguns]

Wow, well you have done well for yourself, no doubt. I have been collecting Excel books probably since its inception, and still can't figure some things out. Just keep loving the fact that so many Excel Gurus are on this forum to help. So thank you once again, and you have a fabulous day!

 

[sandy666]

Basic is: Excel functions (alphabetical)
If you know that all you'll be a guru as well