brgdotnet
asked on
How to get a column of data out of excel, and to seperate the items with a comma
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Please refer to the attached. In column B is the formula that adds the comma to the SSN. You can enter that formula in the first row of your spreadsheet and then copy down. Concatenate joins multiple strings into one.
Concatenate.xlsx
Concatenate.xlsx
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Awesome. Thank you Experts, I will award the points later this evening.
ASKER
I couldn't get the excel formula to work?
ASKER