S
Suzanne
I am retrieving data from an Excel spreadsheet where the column is formatted
"General" (I've also tried formatting as "Text")
The data in this column are variations of room numbers (e.g., B-13, 121,
140-A)
When performing the merge, some room numbers showed up as "0" (zero)
There is no identifiable condition/trend that would make some rooms "0"
(i.e., a "0" may/may not follow another room expressed properly and/or the
same room number). Actual merged data with correct Excel data:
MERGED DATA EXCEL DATA COMMENT
Building Room Room
1422 110 110
1422 110 110
1422 110 110
1422 110 110
1422 110 110
1422 110 110
1422 190 190
1422 190 190
1422 190 190
1422 132 132
1422 130 130
1422 190 190
1422 132 132
1422 140 140
1422 132 132
1422 136 136
1422 190 190
1422 141 141
1422 190 190
1422 141 141
1422 132 132
1422 132 132
1422 190 190
1422 123 123
1422 130 130
1422 130 130
1422 191 191
1422 132 132
1422 190 190
201 0 126
201 0 130
201 0 128-D
201 0 126
201 128 128
201 0 130B
201 122 122 Once a “0†not always a “0â€
201 0 122
201 0 122
201 122 122
201 122 122
201 0 132
201 0 132
201 0 132
201 0 132
201 0 132
810 0 B-13 Perhaps coincidental,
810 0 B-13 no room with a letter
810 0 B-13 is merged properly
810 0 B-13 (but not all improperly
810 0 B-13 merged rooms contain
810 0 B-13 letters)
810 0 B-13
810 0 B-13
810 0 B-13
1422 103 103 (New bldg merged properly)
1422 0 105
1422 0 105
1422 122 122
1422 103 103
1422 119 119
1422 124 124
1422 0 104
1422 0 104
1422 121 121
1422 133 133
1422 121 121
1422 100 100
1422 0 105
1422 100 100
1422 125 125
1422 144 144
1422 192 192
1422 144 144
1422 130 130
1422 190 190
1422 191 191
1422 143 143
1422 195 195
1422 194 194
1422 190 190
1422 145 145
1422 141 141
1422 142 142
1422 134 134
1422 141 141
1422 136 136
1422 135 135
1422 190 190
1422 146 146
1422 136 136
1422 130 130
1422 192 192
1422 124 124
1422 121 121
1422 125 125
1422 122 122
1422 103 103
1422 0 105
201 0 128-G
810 0 B-13
810 0 B-13
810 0 B-13
"General" (I've also tried formatting as "Text")
The data in this column are variations of room numbers (e.g., B-13, 121,
140-A)
When performing the merge, some room numbers showed up as "0" (zero)
There is no identifiable condition/trend that would make some rooms "0"
(i.e., a "0" may/may not follow another room expressed properly and/or the
same room number). Actual merged data with correct Excel data:
MERGED DATA EXCEL DATA COMMENT
Building Room Room
1422 110 110
1422 110 110
1422 110 110
1422 110 110
1422 110 110
1422 110 110
1422 190 190
1422 190 190
1422 190 190
1422 132 132
1422 130 130
1422 190 190
1422 132 132
1422 140 140
1422 132 132
1422 136 136
1422 190 190
1422 141 141
1422 190 190
1422 141 141
1422 132 132
1422 132 132
1422 190 190
1422 123 123
1422 130 130
1422 130 130
1422 191 191
1422 132 132
1422 190 190
201 0 126
201 0 130
201 0 128-D
201 0 126
201 128 128
201 0 130B
201 122 122 Once a “0†not always a “0â€
201 0 122
201 0 122
201 122 122
201 122 122
201 0 132
201 0 132
201 0 132
201 0 132
201 0 132
810 0 B-13 Perhaps coincidental,
810 0 B-13 no room with a letter
810 0 B-13 is merged properly
810 0 B-13 (but not all improperly
810 0 B-13 merged rooms contain
810 0 B-13 letters)
810 0 B-13
810 0 B-13
810 0 B-13
1422 103 103 (New bldg merged properly)
1422 0 105
1422 0 105
1422 122 122
1422 103 103
1422 119 119
1422 124 124
1422 0 104
1422 0 104
1422 121 121
1422 133 133
1422 121 121
1422 100 100
1422 0 105
1422 100 100
1422 125 125
1422 144 144
1422 192 192
1422 144 144
1422 130 130
1422 190 190
1422 191 191
1422 143 143
1422 195 195
1422 194 194
1422 190 190
1422 145 145
1422 141 141
1422 142 142
1422 134 134
1422 141 141
1422 136 136
1422 135 135
1422 190 190
1422 146 146
1422 136 136
1422 130 130
1422 192 192
1422 124 124
1422 121 121
1422 125 125
1422 122 122
1422 103 103
1422 0 105
201 0 128-G
810 0 B-13
810 0 B-13
810 0 B-13