Ask Your Question

Excel, How to enter a cell, then / as char/text, then different cell

asked 2018-02-16 16:57:30 +0100

TurboGoKart gravatar image

Minus the quotes, I am trying to get my destination cell to display: "1/1" where the first 1 is a cell, and the second 1 is another cell.

Here was what I tried, which doesn't work: ='Medical Equipment'!$C$38, "/", 'Medical Equipment'!$D$38

Is this possible? Trying to show how many were checked (C38), out of how many were required (D38).

edit retag flag offensive close merge delete


What is "Excel"?

Mike Kaganski gravatar imageMike Kaganski ( 2018-02-16 16:59:14 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2018-02-16 16:59:50 +0100

updated 2018-02-16 17:03:13 +0100

Use & to concatenate strings in LibreOffice Calc.

Also there are: CONCAT; CONCATENATE; and TEXTJOIN (the latter allows to explicitly define the delimiter string).

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-02-16 16:57:30 +0100

Seen: 34 times

Last updated: Feb 16 '18