Excel - COLUMN Function Problem - Expert Solution

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

Hey, when I download a file from a website and open it in Excel the column names all appear in Row 1 Column A rather than multiple columns. For example, the following field would all be in Row 1 Column A: "register department, service department, rendering provider" But what should happen is "register department" should be in Row 1 Column A, and then "service department" should be in Column B, and "rendering provider" should be in Column C. This happens on my computer but on my husband's computer it opens correctly.
Solved by B. H. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 01/09/2018 - 04:31
Hello
User 01/09/2018 - 04:32
Hi
Excelchat Expert 01/09/2018 - 04:32
How are you today?
User 01/09/2018 - 04:32
Good thanks, you?
Excelchat Expert 01/09/2018 - 04:32
I am great, thank you!
Excelchat Expert 01/09/2018 - 04:33
I read the description mentioned by you. Can you please share the file and tell me more on the problem you are facing!
User 01/09/2018 - 04:34
Ok, one second
Excelchat Expert 01/09/2018 - 04:34
Sure
User 01/09/2018 - 04:37
Here it is
[Uploaded an Excel file]
User 01/09/2018 - 04:38
I think it might have something to do with "comma separated values"
Excelchat Expert 01/09/2018 - 04:38
Ok, Please allow me a minute to look into it
Excelchat Expert 01/09/2018 - 04:38
Yes, this is a csv
Excelchat Expert 01/09/2018 - 04:39
are you downloading this file from somewhere?
User 01/09/2018 - 04:39
yes, from a website
Excelchat Expert 01/09/2018 - 04:39
Ok
Excelchat Expert 01/09/2018 - 04:39
If possible please download the excel or when you are downloading the file save it as excel
Excelchat Expert 01/09/2018 - 04:40
2nd option is we can correct this csv to the get the fiel we want
Excelchat Expert 01/09/2018 - 04:40
the file you shared has header name separated in different columns!
Excelchat Expert 01/09/2018 - 04:41
is this the original file you have downloaded from the website or you have separated the headings in different columns?
User 01/09/2018 - 04:41
it's not the original
Excelchat Expert 01/09/2018 - 04:42
Please download a original file and I will take you through the process!
User 01/09/2018 - 04:42
so the problem is that if i download it on this computer it actually does separate everything into different columns
User 01/09/2018 - 04:43
but the computer my wife is using does not separate it
User 01/09/2018 - 04:43
do you think it's a setting in Excel?
Excelchat Expert 01/09/2018 - 04:43
Ok. Do you follow the same process on both the computer?
Excelchat Expert 01/09/2018 - 04:45
Yes, this is because of the setting on Excel - region settings
User 01/09/2018 - 04:45
Yes, I just tested it and it's the same process
User 01/09/2018 - 04:46
oh ok, what change to the excel settings should i make on my wife's computer?
Excelchat Expert 01/09/2018 - 04:46
I will suggest not to change these setting
Excelchat Expert 01/09/2018 - 04:46
But if you want I can guide you through it
User 01/09/2018 - 04:46
i would like to make the change
User 01/09/2018 - 04:46
or else i need an easy way to reformat it
Excelchat Expert 01/09/2018 - 04:46
Ok
Excelchat Expert 01/09/2018 - 04:47
I will tell you the easy way
Excelchat Expert 01/09/2018 - 04:47
Please open the original file downloaded!
User 01/09/2018 - 04:47
ok
Excelchat Expert 01/09/2018 - 04:47
Select Column A (which has all the data)
User 01/09/2018 - 04:47
ok
Excelchat Expert 01/09/2018 - 04:47
Now go to Data tab on top
User 01/09/2018 - 04:48
ok
Excelchat Expert 01/09/2018 - 04:48
Under Data Tools - Select Text to Column
Excelchat Expert 01/09/2018 - 04:48
it will open a pop up window
User 01/09/2018 - 04:48
ok
Excelchat Expert 01/09/2018 - 04:48
Select - Delimited - Click Next
User 01/09/2018 - 04:49
ok
Excelchat Expert 01/09/2018 - 04:49
Now check mark the comma option
Excelchat Expert 01/09/2018 - 04:49
Click Next, Click Finish
Excelchat Expert 01/09/2018 - 04:49
and you have the data as required!
User 01/09/2018 - 04:50
great, thank you so much?
User 01/09/2018 - 04:50
!
Excelchat Expert 01/09/2018 - 04:50
Did you get the correct data?
Excelchat Expert 01/09/2018 - 04:50
formatted correctly
User 01/09/2018 - 04:50
yes, it reformatted correctly
Excelchat Expert 01/09/2018 - 04:50
Great!
Excelchat Expert 01/09/2018 - 04:50
If you want to change settings
Excelchat Expert 01/09/2018 - 04:50
this is how to do it
Excelchat Expert 01/09/2018 - 04:51
Control Panel -> Regional and Language Options -> Aditional Settings -> Decimal Separator : click to enter a dot (.) and to List Separator enter a coma (,) . This is !
Excelchat Expert 01/09/2018 - 04:51
Also, if you are satisfied with my solution, please go ahead and end the session using the button on the top right hand side and requesting you to provide good feedback and review so that I can continue my services to others.
User 01/09/2018 - 04:51
ok understood
User 01/09/2018 - 04:51
will do!
User 01/09/2018 - 04:51
Thanks again!
Excelchat Expert 01/09/2018 - 04:51
Thank you and have a great day ahead!

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