# Excel - COLUMN Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

how can i apply excel formula to list data in c#.Net console application. I need to apply the excel formula to entire column to calculate the data.
Solved by K. L. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 18/07/2018 - 01:43
Hi
Excelchat Expert 18/07/2018 - 01:43
Welcome to Got it Pro
User 18/07/2018 - 01:43
Hello
Excelchat Expert 18/07/2018 - 01:43
User 18/07/2018 - 01:43
i have data in excel
User 18/07/2018 - 01:43
working in C# console application
User 18/07/2018 - 01:44
i took that data into list
User 18/07/2018 - 01:44
now i need to apply some excel formula to the list
User 18/07/2018 - 01:44
to calculate
Excelchat Expert 18/07/2018 - 01:45
I can help you with formulas in excel..if you have list of data in excel then i can help you with formulas on it
Excelchat Expert 18/07/2018 - 01:45
Not sure how formula works on other applications
User 18/07/2018 - 01:45
i have colum a, b, c
Excelchat Expert 18/07/2018 - 01:46
User 18/07/2018 - 01:46
i need the addition of abc in colum e
User 18/07/2018 - 01:46
ok
User 18/07/2018 - 01:46
=CONCATENATE(F17," ",\$W\$1)
User 18/07/2018 - 01:46
my excel formula
User 18/07/2018 - 01:47
for colum x
User 18/07/2018 - 01:47
how can i write in C#.Net
Excelchat Expert 18/07/2018 - 01:47
Excelchat Expert 18/07/2018 - 01:48
https://docs.microsoft.com/en-us/dotnet/csharp/how-to/concatenate-multiple-strings
Excelchat Expert 18/07/2018 - 01:49
Please refer this and let me know if this helps
Excelchat Expert 18/07/2018 - 01:49
This platform is designed for formulas in excel. Not sure about other domains
User 18/07/2018 - 01:50
no
User 18/07/2018 - 01:50
User 18/07/2018 - 01:50
how can past my data in your excel
User 18/07/2018 - 01:50
i am not able to paste
Excelchat Expert 18/07/2018 - 01:50
User 18/07/2018 - 01:51
you know .Net?
Excelchat Expert 18/07/2018 - 01:51
not much. This platform is not meant for .net
User 18/07/2018 - 01:51
ok
Excelchat Expert 18/07/2018 - 01:51
This portal is for excel
Excelchat Expert 18/07/2018 - 01:51
=CONCATENATE(A1:C1)
User 18/07/2018 - 01:51
yes
User 18/07/2018 - 01:51
but excel with .Net
Excelchat Expert 18/07/2018 - 01:51
This is the formula we use for concatenation in excel
User 18/07/2018 - 01:52
working on automation of excel work
User 18/07/2018 - 01:52
yes
User 18/07/2018 - 01:52
i want to autmate the excel formula using .Net
User 18/07/2018 - 01:52
insted of applying this formula in each cell
Excelchat Expert 18/07/2018 - 01:53
using System; class Program { static void Main() { // ... Create a new string reference. // It points to the literal. string s1 = "string2"; // ... Add another string to the start. string s2 = "string1" + s1; Console.WriteLine(s2); } }
User 18/07/2018 - 01:53
will automate
Excelchat Expert 18/07/2018 - 01:53
Excelchat Expert 18/07/2018 - 01:53
https://www.dotnetperls.com/string-concat
Excelchat Expert 18/07/2018 - 01:53
User 18/07/2018 - 01:54
no
Excelchat Expert 18/07/2018 - 01:54
User 18/07/2018 - 01:54
ok
Excelchat Expert 18/07/2018 - 01:54
IF you have anything in excel please let me know
Excelchat Expert 18/07/2018 - 01:54
User 18/07/2018 - 01:54
thank you
Excelchat Expert 18/07/2018 - 01:54
Welcome
Excelchat Expert 18/07/2018 - 01:54
Have a great 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.

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.