How do you replace only *part* of a cell in MS Excel?
921289
If you are only trimming the 0 from the front ( which is what I get from your description ) just use the RIGHT function. Add a column to the right of your data and use this formula.\n\n=RIGHT(A1,LEN(A1)-1)\n\nYou will need to change the A1 to match the reference of your first cell; then just copy the formula alongside your data.\n\nTo eliminate the formulas once the 0s are gone, just select the data in the new column, Copy, then Paste Special... over your original data. Now you can delete the new column.
636777
=(cell number+cell number) \nYou just have to click on the cell that has what you want added, subtracted or multiplied. Simple, really. And you can use more cells than that. Have fun.\nAnother formula might be \n=A(cell number+cell number)
366534
It completely depends on where you are using this formula, is it in Excel? A program? What language?\n\nWe need more info.
1121474
Well there are a few ways.... the easiest way is.........\n\nLets say you want to get rid of everything in row 5, you can move your mouse over the letter 5 at the very left and highlight that row by left clicking once, then right click your mouse and select delete. This however will only delete information you entered like letters or numbers. If you applied any borders or the like you will need to highlight the row as stated above, right click and go to "Format cells" then to the  borders tab and choose "none".\n\nThis will work for deleting entire columns also.
1038128
Yes there is a way to do this, but you'll have to split the master document up into about 4 spreadsheets.  There's only one good way of doing this if you don't want to spend years matching these together and that is with a macro.  The problem is that macros take a descent little bit of expertise to develop.  So it's time for me to give you a crash course in macros.  First you need to make sure that your security level in Excel for macros is set to Medium or Low.  From the menu bar, go to Tools, Macro, Security.  Reset it to Medium save the file, then restart Excel.  Excel needs to be restarted for the change to take effect.  Now on to creating macros.  Go to Tools, Macro, Record New Macro.  Pick a name for your macro then click OK.  Don't do anything whatsoever to the Excel workbook, just click the stop button.  This creates basically a blank macro named Macro1 or whatever you called it in your workbook.  Now we want to go edit that macro.  Go to Tools, Macro, Macros.  \n\nNow select your macro and click Edit.  Now past the following text in as macro code:\n\n'Set column A to your part number and column B to your lead time\nFor Each x In [Doc2! A:A]           'Looks through every cell in column A in a worksheet called Doc2\n    If x.FormulaR1C1 = "" Then      'Tells computer to end the search if it reaches\n        Exit For                    'a blank cell in column A of Doc2\n    End If\n    \n    For Each y In [Doc1! A:A]       'Looks through every cell in column A in a worksheet called Doc1\n        If y.FormulaR1C1 = "" Then  'Tells computer to go to the next part number in Doc2 if it reaches\n            Exit For                'a blank cell in column A of Doc1\n        End If\n        \n        If x.FormulaR1C1 = y.FormulaR1C1 Then           'Compares the part numbers to see if they match\n            x.Offset(0, 1).Value = y.Offset(0, 1).Value 'Sets column B in Doc2 equal to column B in Doc1 (your lead times)\n            Exit For                                    'Moves to next part number in Doc2\n        End If\n    Next y  'Moves to next part number in Doc1\nNext x      'Moves to next part number in Doc2\n\n\nEverything after an apostrophe is comments and will appear green.  This will have no affect on how the macro runs.  You will need to modify the macro or you worksheets so the macro works properly.  The code gets pasted between the Sub Macroname and End Sub portions.  The comments I listed should help you understand how the macro works.  Here's something REALLY IMPORTANT!!!  Save your workbook BEFORE you run the macro.  You can't undo what a macro does by hitting the undo button.  So if it doesn't do what you want, simply close the file without saving it.\n\nContact me, I probably need to explain a few more things too you.  Since your master list is over one spreadsheet long there are going to be some complications you'll have to work through that could make it very difficult, even for a macro.  \n\nMacros can save hours or days of time, but they can be difficult to a new user.  The Visual Basic 6 Blackbook by Coriolis is a good reference guide if you want to learn to write macros in Excel.  Just remember the coding may be a little different in Excel than for writing a program in VB6.
494290
Yes, this is possible, except the idea is a little backward. Instead of protecting one column, you will actually be protecting the entire sheet and making all other columns editable.\n\nTo do this, identify the cells you want to editable. So let's say you wanted to protect column C. You would want columns A:B,D:IV editable.\n\nIn the menu go to Tools > Protection > Allow Users to Edit Ranges.\n\nA box pops up. Click the "New" button. This will allow you to specify the range of cells you want to leave editable. So in our case, in the "Refers to Cells" box, you would type in: =A:B,D:IV\nAnd then click OK. Excel will automatically add dollar signs to 'lock in' the range.\n\nNow click "Apply" button. Then click the "Protect Sheet..." button. Another pop-up will show asking for you to enter a password. Once you complete that, all the cells in the "editable" range will still be free to edit. The cells in the protected column will be locked.\n\nNote: Depending on the check boxes you select in the "protect sheet..." box, the user may or may not be able to add or delete columns. If you want to grant the user this functionality, you must activate those check boxes.
1065789
Make sure source works. and destination s.has cells selected as numbers. I assume you know how to do it. But here it is in case:\nSelect column. Right click it and go to format cells.Stay in number tab and select number. \nIt should work fine.
596850
Do these words have only numbers? or do they have extra letters?\nIf the numbers you need to convert are in the beggining of the cell, use the Value function\n=value(A1)\nassuming that the cell you want to convert is in A1\n\notherwise\nsend me you e-mail address , and I will be happy to help\n\nI am the XLMan
916002
format the whole thing
330924
Say you have in Cell A1 of "Sheet1" is -400...\nif you want it on Cell A1 of "Sheet2" as +ve number no matter A1 on Sheet1 will change to +ve or -ve, then put   =ABS(Sheet1!A1)\nif you want it on Cell A1 of "Sheet2" as +ve number only when A1 on sheet1 is -ve (reverse sign) then put =-Sheet1!A1\nif you want no formula as above 2, copy A1 on Sheet1, right click A1 on Sheet2 and choose paste special, check the subtract and click ok
586461
I thought the istext formula would work but they don't.\nHere's another way to solve this issue. Assume the cell to test is in A1, enter the following formula in another cell:\n\n=IF(ISERROR(LEFT(A1,1)/1) ,"yes","no")
646340
To completely automate the deletion of duplicates you have to code (not record) a macro. However, with some manual intervention you can do it without any code.\n\nThese methods assume your data is in one or many columns of contiguus data with a label in the first row)\n\nMethod 1 (more manual)\nSort your data\nScan for the dups and delete the rows\n\nMethod 2 (less manual)\nClick anywhere in the data you are working on\nGo to Data, Filter, Advanced Filter\nIn this new window select the following:\n Copy list to another location\n Your list range should already be selected\n Click in Copy To and select a destination cell\n Click Unique Records Only\n Click OK
398262
replace space with %20
1107100
Select the cells that you want this special formatting applied to, then select the 'Conditional Formatting' option from the 'Format' menu at the top of your screen.\nIn the 'Conditional Formatting' wizard, select 'Cell Value Is', then select 'Equal to', and in the third box type the letter 'x' (or whatever value you want).  Then click the 'Format' button and choose the formatting effects you want applied when your chosen value is entered.  Then just click 'OK' until done.  Best of luck!
1105719
In Excel, functions and macros only can do this. Try the functions PROPER, UPPER and LOWER.\n\nCtrl+Shift+A is another Word keystroke for changing case, it doesn't work in Excel.\n\nCheck out:\nhttp://www.mvps.org/dmcritchie/excel/proper.htm#upper
709713
You can simply use an "IF" statement.\n \nLet's say in A column some cells have values & some don't - for the one that has a value (non-blank), you'd like put the number "2" next to it (in the B column), here the formula -\n\n=IF(A1<>="",2,"")\nThis means if A1 is not blank, then put 2 in B1, otherwise leave it blank.
694733
Go to Tools, Options, Edit, check Typing Replaces Section.\nThat ought to do it.\nPlease don't forget to award 10 points!\n-MM