Excel 2010 - Split text between colunms

Hi,

I have Excel 2010 and my xls file has the following table (eveything in onde single colunm):

#TAC,Number Of Subscribers
35828142,99
35828141,96
35763676,54
35955607,49
1384100,414
35750024,3
35933030,26
35513013,23
35561017,22

Is there a way to 2 colunms? Like this: One for TAC and one for Number Of Subscribers instead of only one for both?

The values of each is separated by comma.

Tks,
Joao
joaotellesAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
helpfinderConnect With a Mentor IT ConsultantCommented:
yes, of course.
Use Text To Columns and comma (,) a Delimiter

01
02sample.xlsx
0
 
dani gammonProduct Operations ManagerCommented:
Highlight your column and go to: Data --> Text to Columns --> choose 'delimited' --> click next --> choose 'comma' --> click next --> click finish.

Your numbers will be separated into two columns.
0
 
joaotellesAuthor Commented:
Tks.
0
All Courses

From novice to tech pro — start learning today.