Format (Underline) Text With A Formula?

May 19, 2013

I need to underline text which is populated from a formula. How to format numbers, dollars and dates within a formula, but how to underline text.

Desired Result: The employee's who sold more than 100 cars this month are: Alex, Mike and Tim. Please congratulate them on their performance!

Formula being used ="The employee's who sold more than 100 cars this month are: "&cell reference&"Please congratulate them on their performance!"

Current result: The employee's who sold more than 100 cars this month are: Alex Mike Tim Please congratulate them on their performance!

Attempts: I wish underlining text were an option within Format Cells/Custom so I could just use the formula =text(cell reference, "underline"). However, I don't see that as an option in the 2007 or 2010 versions. Is there a way to add "underline text" as my own custom format?

I also tried using "Conditional Formatting" (both "Format cells only that contain" and "Use a formula to determine which cells to format)." I can't quite get it because I don't know how to list names for the former conditional formatting. Vlookup is the only way I know how to refer to a list for the formula based conditional formatting, but this would stop after the first name on the list is found and ignore the rest of them.

View 9 Replies


ADVERTISEMENT

Format String Text - Underline Or Bold

Jul 23, 2012

Can Excel format text in a formula?

i.e.: =if(R25>6"This is Simple test", "This is the other part part of the test")

and then underline the word "Simple" or to have the word "other" bold.

View 4 Replies View Related

Excel Custom Format A Value With Bold And Underline

Sep 26, 2011

The formula is ="Total: " &SUM(B2:B10) Can you make the result appear bolded and underline. Just the result from the =SUM formula not the text Total.

View 1 Replies View Related

Underline Text With Different Color

Aug 24, 2009

Is it possible to underline text with differenet color? Text is let say std. black, and need red underline. (I can change color of cell down but I would like underline line in right test test. underline.xls

View 3 Replies View Related

Format Text In Formula

Oct 5, 2007

How can I underline the formula in a text like so:

My name is Powder

from this formula

="My name is "&D29

View 3 Replies View Related

Retaining Text Format When Using Formula?

Feb 12, 2014

I am using the VLOOKUP function in a cell, however, I would like the value returned to also retain the text format from the table (eg colour and bold). I have attached a simple example (to demonstrate the point) where cell B14 should have the word 'French' in bold red.Example.xlsx

View 3 Replies View Related

Formula Not Working Because Data In Text Format?

Aug 14, 2013

I am downloading my data in the eze tab. Column b is in a text format. How can I amend my formula on the trading statistcs tab for my sumproduct formula to work?

View 7 Replies View Related

Formula Would Copy Over The Format And Change The Text

Oct 15, 2009

i'm having trouble working coming up with a formula. I have a list of people and if i put a x next to their name, i want their name to cross outs. the IF formula does not copy over the format (strikethrough, italics). my question is, what formula would copy this over and change the text?

View 4 Replies View Related

Formula Turns Cell To Text Format

May 7, 2007

I have a workbook with two worksheets. I added a formula to the first worksheet
= COUNTIF(Scorecard!H3,"K"). It works fine when I add another COUNTIF that references another column (baseball fans may realize I'm counting total strikeouts for a batter): =COUNTIF(Scorecard!H3,"K")+COUNTIF(Scorecard!L3,"K") However, when I try to expand this to cover more columns, =COUNTIF(Scorecard!H3,"K")+COUNTIF(Scorecard!L3,"K")+COUNTIF(Scorecard!P3,"K")

Excel automatically changes the format of this cell to "Text" and it shows the formula as text instead of calculating it. What could be wrong here? Excel's documentation is woefully inadequate for cases like this. Is there an undocumented limit on how many times I can add COUNTIFs together?

View 5 Replies View Related

Highlite Or Underline Active Cell Row

May 28, 2009

Is there any way in excel to allow for whenever clicking on an active cell to make an underline or highlite the entire row that that cell is in?

View 2 Replies View Related

Bold, Underline And Italic Greyed Out

May 8, 2009

My spreadsheet is locked and protected, and i have found out that the BOLD, underline and italic functions have been disabled, is there anything i could do via VBA to keep these functions active,...????

View 4 Replies View Related

COUNTIF Function To Autom. Underline

Aug 18, 2009

look at the attached file. How can I have the text values in Column A automatically be underlined if the concerning value in Column C drops below the value "1"? Note that Column C wont give you number values in this sample book as it refers to another file on my hd.

View 4 Replies View Related

BOLD And UNDERLINE Concatenated Cells

Apr 23, 2006

I need bolding and underlining cells that are "Concatenated". For example, cell format for cell K12 is already bolded and underlined. If I concatenate (C1,K12,D2) I get a result that doesn't carry over the format of those individual cells - particularly K12 which I want BOLDED and UNDERLINED.

View 9 Replies View Related

Underline Word In Concatenate Function?

Apr 22, 2014

each cell contains one word say hello in a1 and Henry in b1. Is it possible to underline Henry after =concatenate(a1,b1) ?

View 4 Replies View Related

TextBox Develops Underline After 1st Character

Apr 13, 2008

When I enter some text into a TextBox, the first character is fine, but after the second character has been entered, the font seems to develop an underline. I've created a Word document with screenprints but have been unable to make it small enough to upload here, despite trying for the past couple of hours! You can therefore see the document here ... http://www.keepandshare.com/doc/view.php?id=508384&da=y

View 8 Replies View Related

Revert (Bold) Underline Back To Normal

Jan 12, 2014

What I mean by my "bold" underlines:

QRG5UUl.png

Notice the difference between the bold underline and the normal ones. There is also some weird thing happening where in some cells, when I use the underline feature, it shows as a bold underline, but once I've pressed enter to move on to another cell, the underline reverts back to normal. If I select to edit (F2 or double-clicking) said cell, the underline becomes bold, and vice versa (s3lw.png).

All this started happening immediately after I did this (was just experimenting, and I have no idea what this actually does, or if it was the cause of those occurences): Insert > Symbol > Special Characters > No-width optional break. I did that to just one cell though, and now all this weird stuff is happening.

View 4 Replies View Related

Save Number As Text In Txt Format Wo Changing The Format

Mar 1, 2007

In order to export an excel table into another program I first need to save the excel file as .txt. The .txt file can then be imported by the other program.

First I however need to make excel understand that the value should be a text and not a value. I therefore format the number as text (0000150235) by adding "0000150235". After saving the file as .txt the format changes from "0000150235" to """0000150235""". I do however need the format in the .txt file to be "0000150235". Can anyone tell me how I can save "0000150235" as .txt and get the value "0000150235" in the .txt file.

View 14 Replies View Related

Change A Date In Text Format Into Regular Format

Jan 10, 2007

I have an excel sheet full of dates in text format and want to convert them into regular format. For instance, one of the dates listed is in text as "60801". I'd like it to show in regular date format of mm/dd/yyyy, so that 60801 becomes 8/1/2006.

View 9 Replies View Related

Convert A Date Format To A Text Format

Oct 6, 2008

Example......

In D2 I have: =B2
In D3 I have manually input: (space)3-08

As you can see the CONCATENATE puts the "39569" date in A2 But the second line puts the text date as I prefer. What I would like to do is put in a formula or macro in D2 and down that will change the "Mar-08" to "3-08" so it CONCATENATEs correctly to column A. Simply: I'm trying to avoid manually inputing the text version "3-08" (or whatever M-Y) into D2 down a hundred or so rows!

View 3 Replies View Related

Convert Number Format To Text Format?

Oct 11, 2012

I want to convert number format to text format, any formula ?

View 6 Replies View Related

Convert Text Format To Numbers Format In Vb

Nov 21, 2006

how i convert text format into numbers format in vb.
Currently

i have a formula in vB:

Private Sub Textbox3_Change()
Textbox3 = Val(Textbox1.Value) + Val(Textbox2.Value)
End Sub

however..when i sum it up (in excel) using"=sum" formula...it ooes not sum up

I faced an error "number stored as text"..how to i convert it to numbers format in vb.

View 9 Replies View Related

VBA: Format Amts Into Text $ 9.99 Type Format

Feb 13, 2008

Need to create a set of aligned text amts from various cells...Tried Format but unable to get right combination...I've looked at many threads and most seem related to getting amt from text instead of reverse.

Cell may contain nothing or a monetary amt, negative or positive. Output needs to be in format of "$9,999.99-" or similar...with leading zeros suppressed but a min of "$ 0.00" showing, so that above/below amts with be decimal point aligned in a fixed font situation.

I've almost gotten my routine finsihed but this is last remaining obstacle.

View 9 Replies View Related

Format Number To Text With Specific Format

Sep 14, 2007

I'll get straight to the point: How can I change this text format from 474556788 to 0-47455678-8 (dash added after 0 and before the last number). I need to apply this to around 5000 rows (can't do that manualy). I want it to be int his format:

474556788 to 047-455678-8

Tks Auto Merged Post;474556788 to 047-455678-8 (This is the wanted format)

View 10 Replies View Related

Formula For Changing Date Format 3-12-13 To Format D-mm-yy

Apr 8, 2013

I have a long list of dates that are fomatted as 3-12-13 that I want to format under custom date as d-mmm-yy : 12-Mar-13. I tried to do this but it does not change. I tried to change it to a number and that didn't work either.

View 2 Replies View Related

Converting? Format To Text Format

Sep 15, 2009

On the attached example i have a list of fractions (in the format ?/???). However, i have a problem when the fraction is 6/4 or 4/6 as excel rounds the nominator and de-nominator down to the lowest value so these fractions become 3/2 and 2/3. For these two fractions only i don't want this rounding down to happen.

I am open to any suggestions, but i was thinking of some vba where on pressing a button it would run a macro that went through the cells in the column and if the cell value is 1.5 (3/2) then format the cell as text and enter the value"6/4". For the 2/3 fraction, i think you may need to say if the cell is greater than 0.66 and less than 0.67 because this would possibly be harder to exact as the number of decimal places involved.

View 6 Replies View Related

Format Different Numbers To The Same Format (as Text)

Jan 19, 2010

How to format different numbers to the same format (as text). Mainly I need code that would format numbers like 25, 25.36 or 254.60 to numbers looking like this 000002500, 000002536, 000025460. They must be of nine digit length with the last two digits as decimals.

View 9 Replies View Related

Insert Text In Front Of Text OR Number - User Defined Format

Sep 24, 2008

I can't seem to make user-defined format that puts a text in front of a number and/or a text.

Let's say I have A1: 13, A2: texttext A3: text7 and I want to format a lot of cells to "Ilike 13" / "Ilike texttext" / "Ilike text7"... ie add the same text in the front of the cell, no matter what the content is.

I did manage it seperately, with "texttext" @ for text and "texttext" # for numbers, but what's the general one?

View 12 Replies View Related

How To Format All Caps Text Into Properly Capitalized Text

Aug 8, 2014

I have a few tasks which I have been doing manually because I do not know if there is a way to accomplish these tasks automatically via some excel formulas.

My first task requires me to take an address, for example: 1234 CAMBIE STREET, and format it such that it is properly capitalized (only capital letters in the front of words) like this: 1234 Cambie Street

My second task involves taking an address, for example: 1234 1st Avenue W, and rearranging it such that the direction is in front of the street name like so: 1234 W 1st Avenue. What makes this task potentially even more complicated is that not all the addresses I am working with require the rearrangement, so I can't simply have a formula that puts the last group of characters in front of the first group of characters because that may screw up addresses that don't require this formatting.

My third task demands that 2 columns of names are combined into one column, while also simultaneously placing a "&" between the names. For example: Jonathan Parkinson | Sarah Parkinson turns into Jonathan Parkinson & Sarah Parkinson. Now I do understand how to use a simple combining formula (=a1&" & "&b1) but it isn't that simple. The columns are not all filled with names. Some pairs may have no names, whereas others may have only one name. Because of this, the formula I used as an example will result in many instances where all I see is a "&", and other instances where I see the first name, followed by an unnecessary "&".

So far, for the majority of these problems, I've been using a combination of manual data input, and the replace function, but I really do hope there is a faster and better way to go about these tasks.

View 4 Replies View Related

Format Msgbox Text: Centre/center Some Text

Nov 3, 2006

can you format msgbox? i want to centre/center some text

(also - mods...

....If are you new to the forum, or unsure,...

surely -
...If you are new to the forum, or unsure,........?

)

View 4 Replies View Related

Conditional Format Text If Text Contains

Aug 6, 2008

How do I conditionally format a cell if a particular word is within the text in that cell?

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved