Can you Sparse a field in Excel??? and Database Query??
One way;
See help for test to columns and use a space as the delimiter
HTH
"TotallyConfused" wrote:
How can Sparse a field in Excel? I have a column/field with LastNM, FNM and
Mid all together I need to break it up into a column/field for each part of
the name. Can this be done in Excel? Can you convert a Spreadsheet into a
Table in excel to be able to use New Database Query?
|