Look at Data/Text to Columns
Bob Umlas
Excel MVP

"Pam" wrote in message
...
I'm trying to divide 1 cell into multiple cells - like having a table of 1
row and 27 columns in 1 cell. Does anyone know if that's possible?

It was recommended that I try ALT+Enter - I tried that but it gives me the
equivalent of 1 column with 27 rows.

Any assistance is greatly appreciated.
Thank you,
Pam