Question description:
This user has given permission to use the problem statement for this
blog.
I need a formula to combine column C with data in L26 and L35
Solved by S. D. in 13 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
13/09/2018 - 02:47
Hello! Welcome to ExcelChat. Hope you are doing well
User
13/09/2018 - 02:47
Hi, Yes, how are you?
Excelchat Expert
13/09/2018 - 02:48
I am doing well as well. So it seems like you would like to combine column C with data in L26 and L35
Excelchat Expert
13/09/2018 - 02:48
Could you share a file maybe that shows what type of data you are trying to combine?
Excelchat Expert
13/09/2018 - 02:48
Or maybe you can paste some of the data onto the google sheet to the right?
User
13/09/2018 - 02:49
I cannot really share any of the data
User
13/09/2018 - 02:50
It is mostly integers
Excelchat Expert
13/09/2018 - 02:50
Could you describe the type of data that exists in column C, L26 and L35 maybe to try to find a solution?
Excelchat Expert
13/09/2018 - 02:51
Ok so on the right, let me know if this is what the end result should look like.
Excelchat Expert
13/09/2018 - 02:52
So if I have a 4 in L26, 6 in L34. The result in Column C should be 4,6
Excelchat Expert
13/09/2018 - 02:52
Is that correct? Could you provide more detail what the combination should look like?
User
13/09/2018 - 02:53
yes, this is accurate
User
13/09/2018 - 02:53
also, how to do this automatically with alphabets and words
Excelchat Expert
13/09/2018 - 02:53
Ok great, what should the separation be between the two integers? Should they be separated by a space? A comma?
User
13/09/2018 - 02:53
comma
Excelchat Expert
13/09/2018 - 02:55
Ok, so in cell C1 you will find the formula to combine the two cells. It is using the concatenate function, which basically combines the values in the two cells being called out, separated by a comma.
Excelchat Expert
13/09/2018 - 02:55
Here is the formula: =CONCATENATE(B2," ",A2)
Excelchat Expert
13/09/2018 - 02:56
Does this look correct to you? I have added letters and numbers to the strings in L26 and L34
User
13/09/2018 - 02:56
ah, yes
User
13/09/2018 - 02:56
and how to separate?
Excelchat Expert
13/09/2018 - 02:57
What do you mean by separate?
User
13/09/2018 - 02:57
divide the data in C1 for example to two different columns - maybe D1 and E1
Excelchat Expert
13/09/2018 - 02:57
Let me remind you that we are only able to answer one question per session as the guidelines set by ExcelChat. If this is a different question then we will need to start a separate session to make sure that the right excel expert can answer your question.
User
13/09/2018 - 02:58
oh, I am sorry, I was not aware
Excelchat Expert
13/09/2018 - 02:59
I understand your question now. To answer this question we would need to start a separate session but please come back and we will be able to help out! It requires a different function and there are multiple ways of going about separating that data into different cells so I will let another expert take that question for you.
Excelchat Expert
13/09/2018 - 02:59
But was this session able to answer your original question?
User
13/09/2018 - 02:59
yes, thank you
Excelchat Expert
13/09/2018 - 03:00
Great! Well hope to see you back and let us know how we can help! Thanks so much for joining!
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.