EXCEL-formula help 2

[TomSalvato]

Good afternoon, Experts.
I'm need a formula to calculate COL-C.
If both A and B have data, then I need the result (in COL-C) to show both fields separated by a / character.
If only one of A or B have data, then I need the result (in COL-C) to show just the one field (no / character).
I'm very rusty with these excel if formulas so I'm hoping one of you guys could help me out.
Thanx in advance!

Example - desired results

COL-A COL-B COL-C
3333 3333
2222 3333 2222/3333
9999 9999

 

[SkipVought]

Hi,

Your desired results, I'm guessing...
[pre]
COL-A COL-B COL-C
2222 2222
2222 3333 2222/3333
4444 4444
[/pre]

Formula
C2:=A2&IF(ISBLANK(B2),"","/"&B2)

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]
"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

You Matter...
unless you multiply yourself by the speed of light squared, then...
You Energy!

 

[Andrzejek]

Your 'Example - desired results' are wrong :-(

Try this formula in cell C2: [tt]=IF(OR(ISBLANK(A2), ISBLANK(B2)), A2 & B2,A2 &"/" & B2)[/tt]


---- Andy

"Hmm...they have the internet on computers now"--Homer Simpson

 

[TomSalvato]

Perfect! thanx, Skip!

 

[Andrzejek]

If only one of A [red]or[/red] B have data...

So, this is also a possibility:

[pre]
COL-A COL_B COL_C
2222
2222 3333
4444
5555
[/pre]


---- Andy

"Hmm...they have the internet on computers now"--Homer Simpson

 

[combo]

In Excel 365/2021 you can use TEXTJOIN function directly (

https://support.microsoft.com/en-gb/office/textjoin-function-357b449a-ec91-49d0-80c3-0e8fc845691c

)

combo

 

[TomSalvato]

Combo - never even heard of that formula. Does exactly what I needed. Thanks again, sir.