Break text string up into sub strings of 50 characters

Hi, pretty new to formulas in excel but have a problem to solve....

I need to turn one text string into 5 substrings with a maximum of 50 characters each (250 charaters in all). However, words need to remain intact and cannot be broken in the middle. Each substring will continue in the next column.

I found this formula =MID($A1,1+(COLUMNS($A:A)-1)*49,49)&IF(COLUMNS($A:A)<=INT(LEN($A1)/49),",","") on this post
[URL="http://www.excelforum.com/excel-general/919489-add-a-comma-after-every-49-characters.html"]

It works except that it places commas in the middle of words. In my google search I came across many macro codes to complete tasks like this but when I copied the code and tried to run it nothing happened. Is it possible to run a macro on a just a cell selection or does it run on the entire sheet? If they can only run on an entire sheet then macros will not work.

I do not need commas to break up the string but if they are needed in order to do so that is not a problem.

If you can help it is INCREDIBLY APPRECIATED!

Thank you,
Michael

How does the attached work for you? Formulas are in the yellow cells

That breaks up words..

Try like this (formulas in column B are array entered with CTRL + SHIFT + ENTER)

EFsubstringsof50.xlsx

Thank you both for your answers and sorry for the very late response! The array formula works excellent! Why does it have to be an array formula and not
a regular one?

Thats awesome thanks guys! One more formula needed, how would I add a comma every 50 characters but not in the middle of a text string with a maximum of 5 commas?

It's a new formula, separate from the first one. Doesn't have to divide string into separate cells, just add the commas.