I have a spreadsheet that currently contains numbers and is separated by "XXXXX". I would like to add the number in the previous row to the X's and do the same operation for the whole column. Any thoughts? Here is a sample of my current data:
<colgroup><col><col><col></colgroup><tbody>
</tbody>
<colgroup><col><col><col></colgroup><tbody></tbody>
In column B I need the XXXXX to be replaced with 1190XXXXX. Haven't be able to find any help with this and have been searching for about an hour here.
Thanks, any help would be greatly appreciated.
Bill
A 1 | B 1188 | C |
1 | 1189 | |
1 | 1190 | |
XXXXX | XXXXX | XXXXX |
2 | 1191 | ** |
2 | 1192 | |
2 | 1193 | |
2 | 1194 |
<colgroup><col><col><col></colgroup><tbody>
</tbody>
<colgroup><col><col><col></colgroup><tbody></tbody>
In column B I need the XXXXX to be replaced with 1190XXXXX. Haven't be able to find any help with this and have been searching for about an hour here.
Thanks, any help would be greatly appreciated.
Bill