ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I underline just 1 word in an Excel cell that is a formula? (https://www.excelbanter.com/excel-worksheet-functions/180690-how-do-i-underline-just-1-word-excel-cell-formula.html)

Wayne Ross

How do I underline just 1 word in an Excel cell that is a formula?
 
How do I underline just 1 word in an Excel cell that is created by a formula?

for example, the formula could be: ="Please underline this word." and I want
to underline the word "Word". The actual formula I am working with is
getting words from many other cells within the worksheet.


Dave Peterson

How do I underline just 1 word in an Excel cell that is a formula?
 
Formulas don't allow this kind of character by character formatting.

Wayne Ross wrote:

How do I underline just 1 word in an Excel cell that is created by a formula?

for example, the formula could be: ="Please underline this word." and I want
to underline the word "Word". The actual formula I am working with is
getting words from many other cells within the worksheet.


--

Dave Peterson


All times are GMT +1. The time now is 06:49 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com