Podcast #128: We chat with Kent C Dodds about why he loves React and discuss what life was like in the dark days before Git. Listen now.
3 added 37 characters in body
source | link

Excel/GoogleSheetsGoogle Sheets, 28 bytes

Inspired by @TaylorScott, who used a function that only exists in Excel, I found an even shorter function that only exists in GoogleSheetsGoogle Sheets. Conveniently, it is designed to return strings:

=iferror(join(,"cba"),"abc")

=iferror(join(,"cba"),"abc")

How it works

In GoogleSheetsGoogle Sheets, join([arg1], arg2, arg3,...argk) will concatenate arg2 -> argk, optionally using the separator specified in arg1. In this case, it successfully returns "cba."

Excel has no join function, so iferror sees a problem and returns "abc"

Excel/GoogleSheets, 28 bytes

Inspired by @TaylorScott, who used a function that only exists in Excel, I found an even shorter function that only exists in GoogleSheets. Conveniently, it is designed to return strings:

=iferror(join(,"cba"),"abc")

How it works

In GoogleSheets, join([arg1], arg2, arg3,...argk) will concatenate arg2 -> argk, optionally using the separator specified in arg1. In this case, it successfully returns "cba."

Excel has no join function, so iferror sees a problem and returns "abc"

Excel/Google Sheets, 28 bytes

Inspired by @TaylorScott, who used a function that only exists in Excel, I found an even shorter function that only exists in Google Sheets. Conveniently, it is designed to return strings:

=iferror(join(,"cba"),"abc")

How it works

In Google Sheets, join([arg1], arg2, arg3,...argk) will concatenate arg2 -> argk, optionally using the separator specified in arg1. In this case, it successfully returns "cba."

Excel has no join function, so iferror sees a problem and returns "abc"

2 added 2 characters in body
source | link

Excel/GoogleSheets, 28 bytes

Inspired by @TaylorScott, who used a function that only exists in Excel, I found an even shorter function that only exists in GoogleSheets. Conveniently, it is designed to return strings:

=iferror(join(,"cba"),"abc")

How it works

In GoogleSheets, join(arg1[arg1], arg2, arg3,...argk) will concatenate arg2 -> argk, optionally using the separator specified in arg1. In this case, it successfully returns "cba."

Excel has no join function, so iferror sees a problem and returns "abc"

Excel/GoogleSheets, 28 bytes

Inspired by @TaylorScott, who used a function that only exists in Excel, I found an even shorter function that only exists in GoogleSheets. Conveniently, it is designed to return strings:

=iferror(join(,"cba"),"abc")

How it works

In GoogleSheets, join(arg1, arg2, arg3,...argk) will concatenate arg2 -> argk, optionally using the separator specified in arg1. In this case, it successfully returns "cba."

Excel has no join function, so iferror sees a problem and returns "abc"

Excel/GoogleSheets, 28 bytes

Inspired by @TaylorScott, who used a function that only exists in Excel, I found an even shorter function that only exists in GoogleSheets. Conveniently, it is designed to return strings:

=iferror(join(,"cba"),"abc")

How it works

In GoogleSheets, join([arg1], arg2, arg3,...argk) will concatenate arg2 -> argk, optionally using the separator specified in arg1. In this case, it successfully returns "cba."

Excel has no join function, so iferror sees a problem and returns "abc"

1
source | link

Excel/GoogleSheets, 28 bytes

Inspired by @TaylorScott, who used a function that only exists in Excel, I found an even shorter function that only exists in GoogleSheets. Conveniently, it is designed to return strings:

=iferror(join(,"cba"),"abc")

How it works

In GoogleSheets, join(arg1, arg2, arg3,...argk) will concatenate arg2 -> argk, optionally using the separator specified in arg1. In this case, it successfully returns "cba."

Excel has no join function, so iferror sees a problem and returns "abc"