Ask Your Question
0

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

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

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

Comments

What is "Excel"?

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

1 Answer

Sort by » oldest newest most voted
0

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

Stats

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

Seen: 22 times

Last updated: Feb 16 '18