Can you Sparse a field in Excel??? and Database Query??

  • Thread starter TotallyConfused
  • Start date
T

TotallyConfused

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?
 
J

Jay

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? ...
Click to expand...

Maybe this will help:
Data >> Text to Columns
It depends on how the name components are separated in your column. Before
using this feature, insert some blank columns after the name column;
otherwise, you may overwrite the data in neighboring columns.
 
T

TotallyConfused

Thank you this works just fine.

Jay said:
Maybe this will help:
Data >> Text to Columns
It depends on how the name components are separated in your column. Before
using this feature, insert some blank columns after the name column;
otherwise, you may overwrite the data in neighboring columns.
Click to expand...
 
Top