I want to have a function or macro that if cells have mingled bold text, that only the bold text shall remain in the cells, and all the rest of the text must be deleted.
i have a worksheet which has a price list for parts, about 2500 rows. in the Column C i have a retail price and in Column D have -5% of the C. i need to add Column E -10% of CERTAIN items, the ones in BOLD Only, of Column D. and change the color of that cell, is there a easy way to do this. i have attached screen shot what i mean.
I want text that's in bold in column B in sheet 1 of my spreadsheet to copy over into column A in sheet 2 of my spreadsheet - is there a quick way of doing this using code or a formula?
I am merging columns. Col B has all text in bold. Col C has all text in regular font. When I use ASAP to merge, the merged column comes out all bold. When I use a formula to merge the merged column comes out all regular. What I want is for the merged column to contain the bold text from Col B in bold, and the regular text from Col C in regular.
What I want is...
This is for service plan B: Take all data and transer to new server.
What I am getting is...
This is for service plan B:Take all data and transer to new server.
OR
This is for service plan B:Take all data and transer to new server.
I am doing a club handicap type of scoring awards for a waterski club the info I get off the internet from each event is like this example below.
I need to convert the scores to a simple number value additionally if possible choose only the highest score since I only use one score from each event. some events have 2 or 3 scores per skier.
Then I have a vlookup table setup and functioning to bring the handicap to my main sheet.
John M44.00/1200 3.50/1200 2.00/1200
MARK M41.50/1125 2.00/1125 2.50/1200
DAVID M43.50/1425 1.50/1425 .50/2300
KEN M42.50/1300 5.50/1425 2.00/1425
basically if you replace the / with @ you have your score of 4@12 meters this being 6 more points than say 4@13 since the 12 meter rope is shorter and more difficult to get around the bouy.
So can or should I use a replace "/" with"@". but then what I ultimately need is like 4/12 need to return a number like 96 and 4/13 should give me 90.
Would a vlookup be easiest? Does excel have a function like this?
Additionally it would be great if it can choose the highest score and bring only that into the main sheet.
is these event do have non club members in then as well, can I using my existing vlookup sheet return only those names?
I want to convert a calculated numerical value to a text value, but there are several possible conversions, each stored in a separate named range, referenced in another cell on the row. Normally I would use VLOOKUP and manually put the range name into the formula, so in this instance:
Formula D2=VLOOKUP(C2,Advanced,2) Formula D3=VLOOKUP(C3,Intermediate,2)
But with lots of lines to do, I'd rather take advantage of the range name being present. Is there anyway of getting VLOOKUP to recognise the contents the appropriate cell as the name of a range?
I need a formula to copy a number stored as a text to the number.
I have a formula in, let's say on Sheet1, cell A1: =IF($M$3,TEXT(N7,"0%"),TEXT(N7,"0.0%"))
I then copy this cell to another sheet, let's say Sheet2, cell A1 =Sheet1!A1. I have then have a bar chart linked to this cell, but it's reading it as text and no bars are appearing in the chart - even though the cell in the second sheet is formatted as a number!
FYI - my work around is to link my chart to the underlying data in the formula above, in this case, N7. But then I'm not getting the whole number (%) or decimal (%) that I want when the value is displayed in the chart.
I have put together an excel sheet for how how long a part is on a particular machine. If there are multiple operations on a machine, I separated the operation times with a comma in the cell. I am now trying to get a sum of the total time the part is in a machine. I cannot just use a sum since the commas change the format from number to text. I was hoping I could do a substitution where I change the commas to plus signs and stick an equal sign in front of it and somehow get it to be recognized as a formula instead of a text string. Even then, I would still have to do a sum for the entire row. This is what I have as an example
_______Machine 1______Machine 2______Machine 3_______Machine 4_______Machine 5________Total Time Part 1 _____20________ 10, 10, 10_________________________________________________________50 Part 2 ____15 ____________30____________________________10_______________________________55 Part 3_______________________________5, 15, 60, 10________________________5________________95
I need a column for summing the row of times (Machine Time). It doesn't need to be a one-cell solution. If I need to add a sheet to the file to do operations on the data that is fine. Again, I do not want to use VBA code. I already have a solution in VBA and am trying to do it in the worksheet only. I can get a substitution working to get a single cell into a format like 10+10+10, but that's the easy part of the battle.
I have a workbook with two sheets: Sheet 2 (CustomerVehicleInfo) contains a client database. Sheet 1 is kind of a virtual work order where the mechanic enters the name of a client (in A1) and all his info pops up in cells B4-F4, according to Sheet 2.
I used a simple VLOOKUP for that: =IF($A$1<>"",VLOOKUP($A$1,CustomerVehicleInfo!$A:$E,1),"")
Same formula for cells C4-F4.
Problem is that the client data needs to convert from a formula to static text and next time the mechanic enters a new name in A1 it needs to jump to the next row, starting at B5.
I am about to take on a rather large excel project for our company. The first part is coming up with how to deal with our drafting department's length inputs. In this project, our users will be entering lengths in a unique format. I have to convert that unique format to a standard Foot-Inch-Fraction format.
To try to keep the file size down and keep the complexity down, converting a cell formula to VBA so i can run this on a group of cells rather than repeating my code downward multiple rows on multiple sheets.
It is either this or come up with my own font that will convert it for me but I do not know where to start with that. How to take a stab at converting this to a VB code i can run?
A3 = 1.0108 B3 = 1'-1 1/2"
The code in B3 looks like this:
[Code] .......
An explanation of the unique format we use in our drafting department:
Basic Feet, Inch and Fraction format = 0 . 00 00 = Feet . Inch Fraction
The numbers left of the decimal point are feet. The first two numbers to the right of the decimal point are inches and the next two are sixteenths of an inch.
I have a sheet that uses all vlookup formulas to populate the cells, and then some basic math calculation are done in seperate columns with the results. The problem is, even though the rest of sheet works fine one column is being read as text. I've tried many things to get Excel to read the column as numbers but nothing is working. So far I've tried everything I've found in Ozgrid (Paste special using add and multiply, using a working column)and the simple formatting things built into Excel, but nothing is working. All I need is for the column to be read as a number.
I have a spreadsheet where I enter text values in a cell, e.g. (.5 x .5) x 2 x .009. I want to find a way to automatically populated the cell to the right with the formula version, e.g. =(.5 * .5) * 2 * x .009 and format as three decimal place number.
One other question, is there a way to enter a template for entry in a cell. It would be nice if the text value above would take care of the parenthesis and multiplication signs for me.
I have created an online survey, and people choose ten words (skills) out of 24 possible. Please see screenshot. I would like a formula that does this in layman's terms: "If I see the word "Cooperation" in the source cell, then I'll put "03b" into the target cell; but if I see "Managing" in the source cell instead, I'll put "21a" in the target cell, etc."
I've tried a few IF / Then statements, with no success. Screenshot shows the source cell upper right, and the ten target cells below left with two rows of sample results. I'm guessing the same formula can be in each of the 10 target cells.
Have a macro that copies a formula from each of 100 workbooks to a new workbook. I want to display these formulas as text and want a macro or someway to display these cells as text. I have tried to record a macro that presses the F2 key, the home key and the apostrophe. This works for the one cell but provides the following macro that does not work for anyother cell.
ActiveCell.FormulaR1C1 = _ "'=VLOOKUP($A$30,'G:Variance Reports FY07[Salary Dist Var Repts_Cur Mth.xls]end of July'!$E$76:$G$200,3)" Range("B3").Select
I need to split each line as follows : Each title (in bold and on a new line) and the text who follows should be placed in a new row, copying the date in each new row created.
I'm trying to use the below vba code that was provided by another member. The code show work to bold any text that is found matching the text string provided.
Problem I'm having is that I get a 'Type mismatch' error when the code tries to run, as below:
Public Function Colorandbold() 'USE-COLOR AND BOLD TEXT STRINGS WITHIN TEXT EXCEL VBA 'BROUGHT TO YOU BY WWW.PROGRAMMINGLIBRARY.COM 'CREATED BY MARK SLOBODA
I am trying to bold specific text in a cell. I have found some language that will do this trick to a point. In addition to the word "Foxwood" I would like to bold 9 other specific words in 5 different sheets in this workbook. Is there a way to do this without the cumbersome task of repeating this language 5 times for the different sheets and 9 times for the additional words?
Dim startPos As Integer Dim totalLen As Integer Dim searchText As String searchText = "Foxwood" For Each cl In Sheets("Week1").Range("c3:c100")
I have a sheet full of names, addresses and phone numbers in one cell like this
Albert Young 16 teststreer 12C..................7888-6338
The name Albert Young is bold. The thing is I would like to split the cell putting the names in another colomn. Then it would be ideal to split the addresses and phone numbers as well. But I have no idea how to split any of these. I scanned this from a phone book, the dots are different on each row.
I have a spreadsheet with a pivot table in it. Column "G" has all of the data in it I need to abbreviate, problem is, I only want the values in BOLD face, and there are 3-5 rows seperating each boldfaced item. I would have to manually copy-paste each bold value into a new, 'clean' column ( column "I", or in a new sheet/workbook, it doesn't matter), and lather-rinse-repeat for the next 700+ rows. It sucks. No, it really does. I stumbled upon this website which is seemingly the utopia for excel macro and programming problems, so is there anyone out there that might take the time to walk me through it...?
Every week I have a worksheet compiled with large range of data, being input after many meetings done. The action-owner Names in open/close brackets are among the long text input in one Column (there are not more than 50 rows of data).
My problem is that in the Column every time I have to manually Bold-face the owner names in the cells that have their names, pressing F2 and Bold. Examples: ...(Wilfred)... or ...(Jacky/Joseph)... Can someone please help me with a code, say I can list out a fixed list of selected text and such code will be able to have these selected text (which is names in this case) in the cells bold-faced.
I am creating a sheet with the cell information coming from different cells. I want to bold and/or underline a part of the cell to add clarity.
For e.g. Cell A1 = "Trans X" (Name of the transaction); Cell B1 = "System Y" (System where the transaction exists) Cell C1 = "Type Z" (Type of transaction)
I want to create a cell which has Newsheet.Cell (x,y) = "Name: Trans X System: System Y Type: Type Z"
I created the String by reading and concatenating the values, but I am not sure how to add the formatting to a part of the string.
I'm not too sure if this will be really easy difficult or really difficult but I want to write some code that compares the value of two strings, and any characters that arent in string 2 will be return formatted in bold. For example, if String1 was "The Quick Brown Fox" and String2 was "The Quick Yellow Fox jumped over the lazy dog", String2 would then be returned as "The Quick Yellow Fox jumped over the lazy dog".
I've got a messagebox in my VBA code and I would like to bold the title of the filename that I've stored in a variable. My message box code (even though you probably don't need to see it) is as follows:
MsgBox ("There has been error. Please check the file - " & strFile & " and make sure there are no #REF errors." & vbCrLf _ & "If there are, correct the errors, save the workbook and regenerate the report. If the error still persists, reboot your machine and try again.")
Is this possible, and if so, how would I go about bolding the strFile variable?
