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
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