andiellenb
New Member
- Joined
- Mar 12, 2019
- Messages
- 1
I've inherited an Excel file used for scheduling that has multiple timeslots in one cell - a formatting nightmare!
Is there a way to easily split these (like the text to columns) except for rows?
Thanks!
example row:
[TABLE="width: 806"]
<tbody>[TR]
[TD]Computer Lab 1 [/TD]
[TD] 8:00-8:50 open
9:00-9:30 open
6th Tech -
9:35-10:20
10:20-11:10
Gifted -
11:10-11:40 5th Grade
11:40-12:10 open
12:20-12:50 3rd Grade
12:50-1:50
1:50-2:25 4th Gifted
2:30-3:00 open
[/TD]
[TD] 8:00-8:50
9:00-9:30
6th Tech -
9:35-10:20
10:20-11:10
Gifted -
11:10-11:40 5th Grade
11:40-12:10 2nd Grade
12:20-12:50 3rd Grade
12:50-1:20 open
1:55-2:25 4th Gifted
2:30-3:00 open[/TD]
[TD]Gifted - s
8:00-8:40 1st Grade
8:50-9:30
6th Tech -
9:35-10:20
10:20-11:10
Gifted -
11:10-11:40 5th Grade
11:40-12:10 2nd Grade
12:20-12:50 open
12:50-1:20 1:55-2:25 4th Gifted
2:30-3:00 open[/TD]
[TD]Gifted - Robles
8:00-8:40 1st Grade
8:50-9:30
6th Tech -
9:35-10:20
10:20-11:10
Gifted -
11:10-11:40 5th Grade
11:40-12:10 2nd Grade
12:20-12:50 3rd Grade
12:50-1:20 open 1:25-1:55 1:55-2:25 4th Gifted
2:30-3:00 open[/TD]
[TD]Gifted -
8:00-8:40 1st Grade
8:50-9:30
6th Tech -
9:35-10:20
10:20-11:10
Gifted -
11:10-11:40 5th Grade
11:40-12:10 2nd Grade
12:20-12:50 3rd Grade
12:50-1:45 TESTING 1:55-2:25 4th Gifted
2:30-3:00 open[/TD]
[/TR]
</tbody>[/TABLE]
Is there a way to easily split these (like the text to columns) except for rows?
Thanks!
example row:
[TABLE="width: 806"]
<tbody>[TR]
[TD]Computer Lab 1 [/TD]
[TD] 8:00-8:50 open
9:00-9:30 open
6th Tech -
9:35-10:20
10:20-11:10
Gifted -
11:10-11:40 5th Grade
11:40-12:10 open
12:20-12:50 3rd Grade
12:50-1:50
1:50-2:25 4th Gifted
2:30-3:00 open
[/TD]
[TD] 8:00-8:50
9:00-9:30
6th Tech -
9:35-10:20
10:20-11:10
Gifted -
11:10-11:40 5th Grade
11:40-12:10 2nd Grade
12:20-12:50 3rd Grade
12:50-1:20 open
1:55-2:25 4th Gifted
2:30-3:00 open[/TD]
[TD]Gifted - s
8:00-8:40 1st Grade
8:50-9:30
6th Tech -
9:35-10:20
10:20-11:10
Gifted -
11:10-11:40 5th Grade
11:40-12:10 2nd Grade
12:20-12:50 open
12:50-1:20 1:55-2:25 4th Gifted
2:30-3:00 open[/TD]
[TD]Gifted - Robles
8:00-8:40 1st Grade
8:50-9:30
6th Tech -
9:35-10:20
10:20-11:10
Gifted -
11:10-11:40 5th Grade
11:40-12:10 2nd Grade
12:20-12:50 3rd Grade
12:50-1:20 open 1:25-1:55 1:55-2:25 4th Gifted
2:30-3:00 open[/TD]
[TD]Gifted -
8:00-8:40 1st Grade
8:50-9:30
6th Tech -
9:35-10:20
10:20-11:10
Gifted -
11:10-11:40 5th Grade
11:40-12:10 2nd Grade
12:20-12:50 3rd Grade
12:50-1:45 TESTING 1:55-2:25 4th Gifted
2:30-3:00 open[/TD]
[/TR]
</tbody>[/TABLE]