Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Libreoffice Sheets
- Thread starter dik
- Start date
ChrisHirst
IS-IT--Management
The long way would be to insert n-1 rows (n being the item count in the cell) below each cell in column 'A'with multiple data, then use Data -> Text To Columns ... on each data cell.
Chris.
Indifference will be the downfall of mankind, but who cares?
Time flies like an arrow, however, fruit flies like a banana.
Never mind this jesus character, stars had to die for me to live.
Chris.
Indifference will be the downfall of mankind, but who cares?
Time flies like an arrow, however, fruit flies like a banana.
Never mind this jesus character, stars had to die for me to live.
- Thread starter
- #3
ChrisHirst
IS-IT--Management
Not off hand, as it is not something I have ever needed to do on more than one row of a few cells.
Chris.
Indifference will be the downfall of mankind, but who cares?
Time flies like an arrow, however, fruit flies like a banana.
Never mind this jesus character, stars had to die for me to live.
Chris.
Indifference will be the downfall of mankind, but who cares?
Time flies like an arrow, however, fruit flies like a banana.
Never mind this jesus character, stars had to die for me to live.
- Thread starter
- #5
- Status