Can anyone please enlighten me as to why I have an additional space between ">" and "Serological Typing" in my data when the text string in cell C2 of the attached sample data is viewed in the formula bar? And also how I can possibly remove this additional space from every cell in a column without having to manually delete it within the formula bar for each cell, please?
I've attached some sample data in which I used the TEXTJOIN function in C3 to join the text strings in A3 & B3 together. I then copied the result of the formula and pasted values back in to C2. As you can see, this then leaves an additional space between ">" and "Serological Typing" when viewing the result in the formula bar, which isn't present in the cell.
Bookmarks