I cannot seem to figure this out and it seems so simple.
In Cell A1 I have the string:In cell B1 I want to add a quick formula to combine cell A1 with the letter 'a'. The problem is that it always comes out with a space between 'T2' and 'a'.![]()
T2
Formula in Cell B1:The result: T2 a![]()
=A1&"a"
But I need it to read: T2a
I've tried to use TRIM, CLEAN, and SUBSTITUTE (substitute char(32) for char(160)) but still nothing
is there any way to do this? I will need to repeat this step many times so I'm hoping to use a formula rather than multiple entries
Bookmarks