Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel 5or6 speadsheet cell has information to divide into records

Status
Not open for further replies.

AstroTek

Programmer
Apr 27, 2004
21
US
I have an excel spreadsheet cell with multiple four digit numbers separated by a comma. I would like to create a record for each number with its corresponding fields.

Thanks

AstroTek
 
Hi AstroTek and welcome to Tek-Tips. Have a look at faq222-2244 to find how to get the best from the forum, as your question is a bit non-specific.

From what you say, try looking up the Split() function. Alternatively there is an ODBC driver for CSV files which might do it, depending on data format.

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'If we're supposed to work in Hex, why have we only got A fingers?'
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top