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.
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?'
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.