Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Combine Data
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!!! |
#2
|
|||
|
|||
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!!! |
#3
|
|||
|
|||
Thanks for the quick reply! So do I have to keep the original LTV and CLTV
columns and then the C2 is a function? "Sloth" wrote: 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!!! |
#4
|
|||
|
|||
Typically you would want to keep all three columns. You have a couple
options if that's not what you want. First: Hide columns A and B (right click columns and select hide). This would allow you to change the values later. And you can still access the columns with other formulas (like SUM, MIN, MAX, etc.). Second: Copy and special paste column C (highlight, select copy, right where you want to paste and select paste special). Then select values this will past the results of C without the functions. You can then delete all the columns you don't need. You should typically only do this if you don't plan on changing anything later, or you plan on inputing the information in the new format. Also note: you won't be able to use funtions like SUM, MAX, MIN, etc. because it is all text now. Hope this helps. "NotIT" wrote: Thanks for the quick reply! So do I have to keep the original LTV and CLTV columns and then the C2 is a function? "Sloth" wrote: 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!!! |
#5
|
|||
|
|||
It did help, a lot actually, thank you!!!!
"Sloth" wrote: Typically you would want to keep all three columns. You have a couple options if that's not what you want. First: Hide columns A and B (right click columns and select hide). This would allow you to change the values later. And you can still access the columns with other formulas (like SUM, MIN, MAX, etc.). Second: Copy and special paste column C (highlight, select copy, right where you want to paste and select paste special). Then select values this will past the results of C without the functions. You can then delete all the columns you don't need. You should typically only do this if you don't plan on changing anything later, or you plan on inputing the information in the new format. Also note: you won't be able to use funtions like SUM, MAX, MIN, etc. because it is all text now. Hope this helps. "NotIT" wrote: Thanks for the quick reply! So do I have to keep the original LTV and CLTV columns and then the C2 is a function? "Sloth" wrote: 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!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I combine data from a list? | Excel Discussion (Misc queries) | |||
Import Data Keeps asking for Password | Excel Discussion (Misc queries) | |||
Line Graph Data Recognition | Charts and Charting in Excel | |||
How do I combine tabulated data into a single column and list alphabetically? | Excel Discussion (Misc queries) | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) |