Do you need formulae, or could you just do a one-time

Data/Text to Columns/Delimited/Space character


??

In article ,
shane24 wrote:

Thank you very much. That works very well. However now that I look at
my list a little closer I have some fields that have a middle name or
initial. Is there a way that we can make this formula break down into
3 columns for first middle and last??

Thanks