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.