jonathan92591
Board Regular
- Joined
- Oct 27, 2011
- Messages
- 65
[TABLE="width: 1341"]
<tbody>[TR]
[TD]Excel version:[/TD]
[TD]Excel 2016[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Computer operating system:[/TD]
[TD]Windows 7[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Sample data:[/TD]
[TD]Sheet1
<tbody>
[TD="bgcolor: #cacaca, align: center"]1[/TD]
[TD="bgcolor: #cacaca, align: center"]2[/TD]
[TD="bgcolor: #cacaca, align: center"]3[/TD]
[TD="bgcolor: #cacaca, align: center"]4[/TD]
</tbody>
Excel tables to the web >> Excel Jeanie HTML 4 [/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Formulas/functions being used:[/TD]
[TD] = SUBSTITUTE(SUBSTITUTE(A2,"Left","Right"),"Right","Left")[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Current results:[/TD]
[TD]Sheet1
<tbody>
[TD="bgcolor: #cacaca, align: center"]1[/TD]
[TD="bgcolor: #cacaca, align: center"]2[/TD]
[TD="bgcolor: #cacaca, align: center"]3[/TD]
[TD="bgcolor: #cacaca, align: center"]4[/TD]
</tbody>
<tbody>
</tbody>
Excel tables to the web >> Excel Jeanie HTML 4 [/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]My goal:[/TD]
[TD]Change "Left" to "Right." And, Change "Right" to "Left."[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Error message:[/TD]
[TD]No error message.[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]How error occurred:[/TD]
[TD]Not working correctly.[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Generated in:[/TD]
[TD]Excel[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Thank you, JT[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
<tbody>[TR]
[TD]Excel version:[/TD]
[TD]Excel 2016[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Computer operating system:[/TD]
[TD]Windows 7[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Sample data:[/TD]
[TD]Sheet1
* | A |
Text Needed to Change | |
24" Left Hinge Built-In ADA Compliant Beverage Center | |
24" Right Hinge Built-In ADA Compliant Beverage Center | |
24" Left Hinge Built-In ADA Compliant Beverage Center |
<tbody>
[TD="bgcolor: #cacaca, align: center"]1[/TD]
[TD="bgcolor: #cacaca, align: center"]2[/TD]
[TD="bgcolor: #cacaca, align: center"]3[/TD]
[TD="bgcolor: #cacaca, align: center"]4[/TD]
</tbody>
Excel tables to the web >> Excel Jeanie HTML 4 [/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Formulas/functions being used:[/TD]
[TD] = SUBSTITUTE(SUBSTITUTE(A2,"Left","Right"),"Right","Left")[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Current results:[/TD]
[TD]Sheet1
* | A | B |
Text Needed to Change | Attempt at Changing Text | |
XXX | 24" Left Hinge Built-In ADA Compliant Beverage Center | |
XXX | 24" Left Hinge Built-In ADA Compliant Beverage Center | |
24" Left Hinge Built-In ADA Compliant Beverage Center | 24" Left Hinge Built-In ADA Compliant Beverage Center |
<tbody>
[TD="bgcolor: #cacaca, align: center"]1[/TD]
[TD="bgcolor: #cacaca, align: center"]2[/TD]
[TD="bgcolor: #cacaca, align: center"]3[/TD]
[TD="bgcolor: #cacaca, align: center"]4[/TD]
</tbody>
Spreadsheet Formulas | ||||||||
<tbody> </tbody> |
<tbody>
</tbody>
Excel tables to the web >> Excel Jeanie HTML 4 [/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]My goal:[/TD]
[TD]Change "Left" to "Right." And, Change "Right" to "Left."[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Error message:[/TD]
[TD]No error message.[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]How error occurred:[/TD]
[TD]Not working correctly.[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Generated in:[/TD]
[TD]Excel[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Thank you, JT[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]