Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can you Sparse a field in Excel??? and Database Query??
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can you Sparse a field in Excel??? and Database Query??
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? ... 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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can you Sparse a field in Excel??? and Database Query??
Thank you this works just fine.
"Jay" 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? ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Database Query | Setting up and Configuration of Excel | |||
Query Excel database from desktop | Excel Discussion (Misc queries) | |||
Excel 2003 - New Database Query | Excel Discussion (Misc queries) | |||
Keeping date format of a field inserted from an excel database | Excel Worksheet Functions | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) |