A2=80
B2=100
C2=A2&"/"&B2

The & character is how you combine text strings. You should know that your
output in C2 is text.

"NotIT" wrote:

I have two columns, one is called LTV and one is called CLTV. I want to
combine the data in them into one. For example, if one of the rows in my
excel sheet had an LTV of 80 and a CLTV of 100, I want this info combined
into one cell/row/column that looks like this: 80/100

Is there a way to do this?

Thanks in advance!!!