Dazzawm
Well-known Member
- Joined
- Jan 24, 2011
- Messages
- 3,775
- Office Version
- 365
- Platform
- Windows
Excel 2010
<colgroup><col style="width: 25pxpx" https:="" www.mrexcel.com="" forum="" usertag.php?do="list&action=hash&hash=DAE7F5"" target="_blank"></colgroup><colgroup><col></colgroup><thead>
</thead><tbody>
</tbody>
I have thousands of rows like above where I want to replace the comma for a forward slash but it says protected sheet etc..
How can I get around this please so it results in below? Thanks
Excel 2010
<colgroup><col style="width: 25pxpx" https:="" www.mrexcel.com="" forum="" usertag.php?do="list&action=hash&hash=DAE7F5"" target="_blank"></colgroup><colgroup><col></colgroup><thead>
</thead><tbody>
</tbody>
P | |
---|---|
60 | Inner Dia.1: 21, Inner Dia.2: 100, Overall H.: 101 |
61 | Inner Dia.1: 21, Inner Dia.2: 100, Overall H.: 101 |
62 | Inner Dia.1: 25, Inner Dia.2: 93, Overall H.: 92 |
<colgroup><col style="width: 25pxpx" https:="" www.mrexcel.com="" forum="" usertag.php?do="list&action=hash&hash=DAE7F5"" target="_blank"></colgroup><colgroup><col></colgroup><thead>
</thead><tbody>
</tbody>
Sheet1
I have thousands of rows like above where I want to replace the comma for a forward slash but it says protected sheet etc..
How can I get around this please so it results in below? Thanks
Excel 2010
P | |
---|---|
60 | Inner Dia.1: 21/ Inner Dia.2: 100/ Overall H.: 101 |
61 | Inner Dia.1: 21/ Inner Dia.2: 100/ Overall H.: 101 |
62 | Inner Dia.1: 25/ Inner Dia.2: 93/ Overall H.: 92 |
<colgroup><col style="width: 25pxpx" https:="" www.mrexcel.com="" forum="" usertag.php?do="list&action=hash&hash=DAE7F5"" target="_blank"></colgroup><colgroup><col></colgroup><thead>
</thead><tbody>
</tbody>
Sheet1
Last edited: