Excel - COLUMN Function Problem - Expert Solution

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.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc