I have an Excel document with about 7 columns of data. I need to get one of the columns of data (Lets call it SocialSecurity) out of Excel, put it into a text file, and separate each social security number with a comma. There are about 4000 rows of data, so doing this manually by hand would take too long. So how can I get the column of data out of excel and separate each value with a comma? I can simply highlight a column, and copy it into windows notepad. However I don't know how to separate each social security number with a comma.
Example of data in Excel. Small example involving only 3 records
FirstName | LastName | Age | SocialSecurity
Barry | Engoli | 24 | 655987000
Camry | Boriseli | 34 | 789776666
Brenda | Sammy | 55 | 544667890
End result :
655987000, 789776666, 544667890