Question description:
This user has given permission to use the problem statement for this
blog.
I need a formula to combine column C with the number mentioned in column L26 to L32
Solved by K. E. in 26 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
22/08/2018 - 04:11
Hi
User
22/08/2018 - 04:11
Hi
Excelchat Expert
22/08/2018 - 04:11
can you share the excel with data
Excelchat Expert
22/08/2018 - 04:13
or atleast a sample data
Excelchat Expert
22/08/2018 - 04:13
to combine column C and L values you can use concatinate
Excelchat Expert
22/08/2018 - 04:14
hello you there
User
22/08/2018 - 04:14
how to share the excel
Excelchat Expert
22/08/2018 - 04:15
there is a paperclip symbol on the right side of the is chat box
User
22/08/2018 - 04:17
please wait me a few minute
Excelchat Expert
22/08/2018 - 04:17
no problem
Excelchat Expert
22/08/2018 - 04:20
you there
User
22/08/2018 - 04:21
[Uploaded an Excel file]
Excelchat Expert
22/08/2018 - 04:22
got the file
Excelchat Expert
22/08/2018 - 04:22
which tab do you nee the formula in
Excelchat Expert
22/08/2018 - 04:23
its not in english .. so you would have to explain which column you need the formula
User
22/08/2018 - 04:23
tab M001
Excelchat Expert
22/08/2018 - 04:23
got it where?
Excelchat Expert
22/08/2018 - 04:24
you mention combine column C with the number mentioned in column L26 to L32 but in tab M001 there is no L26-l32
User
22/08/2018 - 04:25
that is a sample data
Excelchat Expert
22/08/2018 - 04:26
ok no problem
Excelchat Expert
22/08/2018 - 04:26
ok so combine c11 with L26-l32?
Excelchat Expert
22/08/2018 - 04:26
and where do you need the formula?
Excelchat Expert
22/08/2018 - 04:27
which column
User
22/08/2018 - 04:28
you can use a example column
Excelchat Expert
22/08/2018 - 04:28
ok sure
Excelchat Expert
22/08/2018 - 04:31
[Uploaded an Excel file]
Excelchat Expert
22/08/2018 - 04:31
does this look right
User
22/08/2018 - 04:34
it's ok, thank you very much
Excelchat Expert
22/08/2018 - 04:34
your welcome..
Excelchat Expert
22/08/2018 - 04:34
please do leave a feedback after you end the session
User
22/08/2018 - 04:35
how to leave feedback
Excelchat Expert
22/08/2018 - 04:35
after you end the session you will get a prompt
Excelchat Expert
22/08/2018 - 04:36
on the right hand corner of the tab there is a done/end session button
User
22/08/2018 - 04:36
ok, goodbye
Excelchat Expert
22/08/2018 - 04:36
byee
Excelchat Expert
22/08/2018 - 04:36
have a nice day
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.