Joining text with hypen separator

[colarguns]

Hi all,

I am currently using CONCATENATE(AR3,"/",AS3) to join text, but the end result looks like (Black/ Rust). Is there anyway to bring that Rust in a little bit? I have also tried (AR3&"/"&AS3), but it still keeps the word "Rust" about one space too far to the right.


I have tried with no success.

AR3 = Black
AS3 = Rust
Objective = (Black/Rust)

Thanks

 

[jtakw]

Hi,

Don't know why you end up with a space there, you must have leading space in AS3, try this:

Book1
	AR	AS	AT
3	Black	Rust	Black/Rust
Sheet166

Cell Formulas
Range	Formula
AT3	=SUBSTITUTE(AR3&"/"&AS3," ","")

 

[Michael M]

Maybe this,

=SUBSTITUTE(AR3&"/"&AS3," ","")

but it depends on whether the "space" is an actual space OR an imported character, usually Char(160), so you may need

=SUBSTITUTE(AR3&"/"&AS3,CHAR(160),"")

 

[colarguns]

That worked! I too have no clue where the extra space came from. I checked both cells, and even aligned all text to the left, but still had the space. However, your fix worked. Thank you!

 

[jtakw]

You're welcome.