Merge adjacent columns?

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Excel
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - Reopens file on first click Anyone seen this behavior? When I open an .xlsx file from explorer (excel not yet open), then after the file is open, when I click on a cell the file refreshes like it just opened again and I have to select the cell again. It only happens on the first click then things are normal. Annoying! Any fix for this? Thanks, Joe Tag: Merge adjacent columns? Tag: 139027
  - 2
    - Printing names There is a View option to see formulae, so I can print the formulas. What about names? I can write code to list the names, put I'd rather print with names displayed. Is there an option to do this in Excel 97, 2000, 2002, or 2003? Tag: Merge adjacent columns? Tag: 139020
  - 3
    - locating duplicate records in a 300,000 record file I previously had help with writing a macro to eliminate duplicate records, and it worked great which told me there are two duplicate records. Now I need to quickly identify them. There is one column of numbers, sorted in numeric order. I just need to place an X in a helper column for each duplicate record so I can then sort by the helper column. Basically for this to be fast, I just want to compare one cell with the one above it. I've yet to figure out how to do that. Any help appreciated! I've googled up a storm and all I'm finding is deleting dupes or placing an X in a helper column but comparing all records in column A which will take too long with 300,000 records. Thanks! Tag: Merge adjacent columns? Tag: 139012
  - 4
    - Access problems with Excel spreadsheet I have a column labeled date, in which some putz has typed in text, such as "Closed", or "OnGoing". Some of the records actually have dates in them, though. When I link to the sheet in Access, it sees that the first several records are text and shows the field as text in Access, causing headaches.The spreadsheet is a report based on several sources and I'm pretty much stuck with it. However, I'm thinking of adding a column to the spreadsheet that could put a bogus date in when it finds nulls, empty strings, or text, such as "1/1/2099" or something, and returns the short date when it finds one. Any ideas? -- Bill Reed "If you can't laugh at yourself, laugh at somebody else" Message posted via http://www.officekb.com Tag: Merge adjacent columns? Tag: 139008
  - 5
    - Drop Down Menu Options? Need a PRO Big thanks to groups user huntermcg for this find. I have entered this into my "ThisWorkbook" - Private Sub Workbook_Open() Dim sh As Object On Error Resume Next Application.CommandBars("Navigate XL-Dennis").Delete Application.CommandBars("Navigate Sheets").Delete On Error GoTo 0 With Application.CommandBars.Add("Navigate Sheets", , False, True) With .Controls.Add(msoControlButton) .TooltipText = "Move Back" .FaceId = 1017 .OnAction = "Move_Back" .BeginGroup = True End With With .Controls.Add(msoControlDropdown) For Each sh In ThisWorkbook.Sheets .AddItem sh.Name Next sh .TooltipText = "SheetNavigate" .OnAction = "Sheet_Navigate" End With With .Controls.Add(msoControlButton) .TooltipText = "Move next" .FaceId = 1018 .OnAction = "Move_Next" End With .Protection = msoBarNoCustomize .Position = msoBarFloating .Visible = True End With End Sub and then I entered this into a module - Private Sub Sheet_Navigate() Dim stActiveSheet As String With CommandBars.ActionControl stActiveSheet = .List(.ListIndex) ThisWorkbook.Sheets(stActiveSheet).Activate End With End Sub Private Sub Move_Back() On Error Resume Next ActiveSheet.Previous.Select End Sub Private Sub Move_Next() On Error Resume Next ActiveSheet.Next.Select End Sub This created a neat little drop down menu for sheet navigation. (thanks to Bob Phillips for the code at http://www.excelforum.com/newreply.php?do=newreply&noquote=1&p=1358771) QUESTION - I've applied this to a project of mine and it works great. Although with my project I have a workbook with over 250 sheets :-) Is their a way to limit the amount of sheets displayed in the drop down box? also if the above is possible... Is their a way to have different set of sheets displayed for each worksheet? For example, on "sheet 1", the drop down only displays sheets 2-5. Upon the users arrival to sheet 4, the drop down menu displays sheets 30-50. Thanks for the help in advance. Tag: Merge adjacent columns? Tag: 139002
  - 6
    - Attempting to use data Validation I am attempting to use Data Validation to create a lookup from a different sheet. What do I need to input into the Source Field so that sheet 1 will pull data from sheet 2? I can see that the souce will populate =$A$2:$A$6. Tag: Merge adjacent columns? Tag: 139001
  - 7
    - Help HI I am trying to count the total of leave taken without the holidays and the weekends i have used the NETWORKDAYS but i dont know what is the formula in order to have a total of vacation taken excluding weekends and holidays so this is the table that i have i am using network days but its not working Total =NETWORKDAYS(B17,C17) B= from C=To Holidays Example B C C52 New Year 1/1/2008 C53 Labor Day 1/5/2008 C54 Independence Day 22/11/2008 C5 Christmas 25/12/2008 PLEASE ADVISE TIA Tag: Merge adjacent columns? Tag: 138996
  - 8
    - Latest MS Update KB943985 Breaks Excel CSV Capabilities Hi, After I installed KB943985 (the one released on March 11th, 2008), my Excel stopped properly opening CSV files. Prior to installation of this update, Excel 2003 was opening the files properly and automatically splitting them into columns. After I installed the update, when opening the exact same CSV file, all the data would appear in the first column (A). I went ahead and uninstalled the update. Now, I am able to open the same CSV file again without problems - it gets split into columns and everything looks good. Did anyone else encounter the same issue? Is MS going to fix it? Thanks, Arsen Tag: Merge adjacent columns? Tag: 138993
  - 9
    - Mass find/replace tool for Excel documents Hello, Not sure if this is where I should be, but I am referring to Excel docs, so I'll start here. I received this email today, and was wondering if anyone had any suggestions: "Wondering if anyone had any recommendations for a mass find/replace tool for use with Excel documents. Many of our departments have dozens if not hundreds of Excel documents that are linked to other spreadsheets on the server. The AD migration has changed the G:\ drive mapping, and now these links need to be updated. Rather than update each spreadsheet manually, weâ??d like to run some type of find/replace on the departmentâ??s G:\ drive to update all the links in one shot. We found a tool called â??ExcelPipeâ?? which seems to work fairly well, but itâ??s pricey and the company is inconveniently located in Australia. Iâ??ve found several shareware/freeware tools, but they seemed either unreliable or lacking features." Any suggestions? Do you need any further information? Thanks! Tag: Merge adjacent columns? Tag: 138992
  - 10
    - Exclude matches in a list --____YYFNYPCQEPRARTJPNJTN____ Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: base64 Content-Disposition: inline; modification-date="Sat, 14 Mar 2008 05:35:30 -0500" QWxsLA0KDQpJIGhhdmUgYSBkeW5hbWljIHJhbmdlIGxpc3QgYnV0IHRoZXJlIGFyZSBtYW55IGR1 cGxpY2F0ZXMgd2l0aGluIDkwMCsgZW50cmllcy4gSXMgdGhlcmUgYW55d2F5IHRvIHByZXZlbnQg ZHVwbGljYXRlcyBmcm9tIHNob3dpbmcgaW4gYSBkcm9wZG93bj8NCg0KRGF2aWQ= --____YYFNYPCQEPRARTJPNJTN____ Content-Type: multipart/related; boundary="____FLAHYDPYDBEUWALLZPCC____" --____FLAHYDPYDBEUWALLZPCC____ Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: base64 Content-Disposition: inline; modification-date="Sat, 14 Mar 2008 05:35:30 -0500" PEhUTUw+PEhFQUQ+DQo8TUVUQSBodHRwLWVxdWl2PUNvbnRlbnQtVHlwZSBjb250ZW50PSJ0ZXh0 L2h0bWw7IGNoYXJzZXQ9dXRmLTgiPg0KPE1FVEEgY29udGVudD0iTVNIVE1MIDYuMDAuMjkwMC4z MjY4IiBuYW1lPUdFTkVSQVRPUj48L0hFQUQ+DQo8Qk9EWSBzdHlsZT0iTUFSR0lOOiA0cHggNHB4 IDFweDsgRk9OVDogMTBwdCBUYWhvbWEiPg0KPERJVj5BbGwsPC9ESVY+DQo8RElWPiZuYnNwOzwv RElWPg0KPERJVj5JIGhhdmUgYSBkeW5hbWljIHJhbmdlIGxpc3QgYnV0IHRoZXJlIGFyZSBtYW55 IGR1cGxpY2F0ZXMgd2l0aGluIDkwMCsgZW50cmllcy4gSXMgdGhlcmUgYW55d2F5IHRvIHByZXZl bnQgZHVwbGljYXRlcyBmcm9tIHNob3dpbmcgaW4gYSBkcm9wZG93bj88L0RJVj4NCjxESVY+Jm5i c3A7PC9ESVY+DQo8RElWPkRhdmlkPC9ESVY+PC9CT0RZPjwvSFRNTD4= --____FLAHYDPYDBEUWALLZPCC____-- --____YYFNYPCQEPRARTJPNJTN____-- Tag: Merge adjacent columns? Tag: 138991
  - 11
    - problem importing xmlss - Worsheet Setting problem during load trying to open an xmlss and I get a message problem during load and in the text box it says: Worksheet Setting I sess the errors are listed in a file c:\documents and settings\xxx\local settings\temporary internet files\content.MSO\580887f9/log but I can't find that file. How can I determine what's wrong with my xml file? Thanks in advance Tag: Merge adjacent columns? Tag: 138990
  - 12
    - Date Comparison Formula Looks like I need some help, please: I have a column (A1:A12) of dates representing the twelve months of a company year (e.g. A1 = April 2007 to A12 = March 2008). In the second column (B1:B12) is a 'cumulative amount due' currency figure representing the sum to date of the monthly expenses claimed by an employee over the company year. The third column (C1:C20) contains the various dates that expenses were reimbursed to the employee. The fourth column (D1-D20) contains a record of the expense amounts reimbursed to the employee over the year. These reimbursements are random and not necessarily on a monthly basis. There might be more than one reimbursement in a month, or there might not be any. The number of reimbursements could exceed twelve in the year, hence using D1:D20 for this column. In the fifth column (E1:E20) I want to show the 'balance of expenses due' (or overpaid) to the employee at the date the reimbursement was made. What I would like to do is calculate the 'balance of expenses due' based on the date that the reimbursement was made (C1:C20), using the 'cumulative amount due' figure (B1:B12) for the same year & month. Example: If a reimbursement was made on 18 June 2007 (assume reimbursement date entered in cell C4 and reimbursement amount entered in cell D4) , then the amount reimbursed to date (sum cells D1:D4) should be subtracted from the 'cumulative amount due' figure in column B1:B12 that corresponds to June 2007 (June 2007 would be in cell A3 and the corresponding 'cumulative amount due' would be in cell B3). Therefore the sum would be (B3-SUM(D1:D4)). The answer should appear in cell E4 How easy is it to compare the year and month of the reimbursement date with the dates in column A1:A12, find the year/month match and use the corresponding 'cumulative amount due' in the calculation? Is this a task for VLOOKUP? I've tried VLOOPUP, but keep getting a #REF! error. Thanks -- Mike -Please remove 'safetycatch' from email address before firing off your reply- Tag: Merge adjacent columns? Tag: 138983
  - 13
    - VBA code needed to AUTOMATE SELECTION of names within VALIDATION I have searched the blogs and cannot seem to locate anything related to my challenge. I know you guys are gurus when It comes to things like this. I have a worksheet that tracks employee productivity for each cost center with a region. My excel worksheet contains three validation dropdowns that use the "indirect" function with various named ranges that link these dropdowns . So for instance lets say that the first dropdown relates to a region, the second relates to a cost center (there can be many cost centers in a region), and the third is a worker in that cost center (there can be many workers in a cost center). So, lets say that I select Northwest Region =E0 10001 (Cost Center) =E0 and Jim Stu, John Doe, Bob Doe, and Jane Done can all be selected from this cost center individually which changes the productivity data for each worker. Drop Down 1 (region) --> Drop Down 2 (cost center) -> Drop Down 3 (Worker) Range1 =3D Region Range2 =3D (indirect function from cell in Range 1) Range3 =3D (indirect function from cell in Range 2) What I would like to do is automate the printing process of the workers within a selected cost center using these already defined ranges. So for example in the example above I want to print all four names dynamically if some one decides that they would like to print all of the workers in ANY cost center. I am looking for the VBA code for this endeavor. Is this feat possible without having to select each and every worker within that cost center? Also, to take it a step further, is it possible to select all workers from every cost center and print all cost centers at once? Tag: Merge adjacent columns? Tag: 138981
  - 14
    - Excel 2007 Problem I just upgraded from Excel 2002 --> 2007 A particular file behaves strangely when saved in the original .xls format. EOMONTH function gets replaced with a currently unused NAME that refers to a formula upon Save. (This screws everything up, of course). Enabling the ATP add-in in the Name manager doesn't seem to make any difference. Saving in .xlsm format does seem to result in a proper file. What is going on? How to prevent it? Do I need to enable the either the regular, or the VBA ATP add-ins? Thanks. --ron Tag: Merge adjacent columns? Tag: 138979
  - 15
    - Combo Box I am trying to duplicate what another person did for consistency but can't figure it out. A Combo Box appears with the black upside-down triangle at the right side of the object. This triangle appears on a printed page just as it appears onscreen. There is another option for a "drop-down box", however, that I can not figure out how to duplicate. A cell appears to just have numbers or text in it, but when the cell is selected the black triangle appears, giving options to select. I can not figure out how to create this in other cells, or even edit the referenced cells which provide the options. The cell prints just like a normal cell - without showing the black triangle drop-down box. Please help! Our company is cheap and out-dated, so we have excel 2000. Tag: Merge adjacent columns? Tag: 138977
  - 16
    - Excel Data Not Visible in Cells 2007 I have two users in my office that use 2007 - myself and my manager. This morning something strange happened to a spreadsheet he was working on. There was data in the first 200 lines of the spreadsheet. somewhere around line 35 and up to line 60 the data - dissapeared. You couldn't see the text in the cells. BUT if you clicked in the cells you could see the info in the formula bar. He clicked save, and then it showed all the information again. This has happend several times over several spreadsheets. Can anyone help explain this?? Thanks Tag: Merge adjacent columns? Tag: 138976
  - 17
    - Problem keeping data synchronised with database query. Hi all, I'm using Excel 2003. I have a spreadsheet containing a database query (inserted using Data->Import External Data->New Database Query) with 5 columns. The 6th column is a notes column, in which the user can type little comments to help them. When clicking "Refresh Data" on the data, I have a problem if a row is deleted, because the Notes cell that was on that line is now inline with the next row. I would prefer it if the notes cell was deleted entirely (or, more specifically, if the entire row was deleted). Is this possible in Excel 2003? I've been through the 3 options in "Data Range Properties" for "If the number of rows in the data range changes upon refresh", but none of them will delete entire rows - only the cells in the data set. I currently have it set to "Insert entire rows for new data, clear unused cells.", and am using a Dictionary object in VBA to read in the "Notes" values, then write them back out after the refresh is completed - is there a better way?! Cheers, RB. Tag: Merge adjacent columns? Tag: 138975
  - 18
    - Strange behavior This is a multi-part message in MIME format. ------=_NextPart_000_0006_01C88562.E7DE8BB0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable A B C D as tr cf x er wr =20 sg rt yu x =20 sd ff x df qw cv x In the above array, columns A,B, & C are formulas. Theey represent a = first name, last name and email address, respectively. The formula for = column D is =3Dif(C2<>"","x",""). I've replicated it down the column.=20 When note that line 3 works correctly, but line 5 does not. Nor does the = formula work in any following rows.=20 I tried the same thing, programming in VB, with similar results. This = must be a setup problem, but I can't figure it out. I'm using Office 2007 SP1, and Vista Home Professional. Any suggestions would be appreciated... Jim ------=_NextPart_000_0006_01C88562.E7DE8BB0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.6000.16609" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY> <DIV><FONT face=3DArial size=3D2>A    B    = C    D</FONT></DIV> <DIV><FONT face=3DArial size=3D2>as    = tr   =20 cf   x</FONT></DIV> <DIV><FONT face=3DArial size=3D2>er   =20 wr           = </FONT></DIV> <DIV><FONT face=3DArial size=3D2>sg   =20 rt   yu   x    = </FONT></DIV> <DIV><FONT face=3DArial size=3D2>sd   =20 ff          x</FONT></DIV> <DIV><FONT face=3DArial size=3D2>df    qw   = cv  =20 x</FONT></DIV> <DIV><FONT face=3DArial size=3D2>In the above array, columns A,B, & = C are=20 formulas. Theey represent a first name, last name and email address,=20 respectively. The formula for column D is =3Dif(C2<>"","x",""). = I've=20 replicated it down the column. </FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>When note that line 3 works correctly, = but line 5=20 does not. Nor does the formula work in any following=20 rows. </FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>I tried the same thing, programming in = VB, with=20 similar results. This must be a setup problem, but I can't figure it=20 out.</FONT></DIV> <DIV><FONT face=3DArial size=3D2>I'm using Office 2007 SP1,  and = Vista Home=20 Professional.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Any suggestions would be=20 appreciated...</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Jim</FONT></DIV></BODY></HTML> ------=_NextPart_000_0006_01C88562.E7DE8BB0-- Tag: Merge adjacent columns? Tag: 138972
  - 19
    - Excel 2003 / Windows Explorer (XP) sort order differs - How to fix? In Excel 2003, mpeg2_MP@H1440_1280x720p_29.97fps_CBR_40Mbs_openGOP_zzscan.mpv comes before mpeg2_MP@H1440_720x576i_25fps_CBR_45Mbs_closedGOP_alternatescan_LFF.mpv In XP's Windows Explorer and also using DIR/ON in a command prompt shell window, the sort order is reversed. How do I reconcile the two so they sort in the same order? Thank you kindly. Tag: Merge adjacent columns? Tag: 138961
  - 20
    - ActiveCell I am trying to achieve If ActiveCell In Range ("C22:K22,C24:K24") Then but I require assistance with the correct syntax. Thanks Sandy Tag: Merge adjacent columns? Tag: 138956
  - 21
    - Excel available resources I am having an error that happens frequently when opening a workbook. It says "Excel cannot complete this task with available resources". It also happens at other times. I have seen this happen at other times as well, but it happens most frequently on workbook open. It happens most when the computer has just come back from the screen saver or having been locked (or both). I am working in Excel 2007 on a machine with 2 GB of RAM and 4096MB of virtual memory. There are plenty of available resources when I check the mem usage in task manager. The information I've read about this error doesn't seem to relate to it. I am not using named ranges, nested names, or an older version of Excel. After closing the error message and a secondary one which has code 101648 after I hit "CTRL+SHIFT+I", the screen becomes messed up. The application toolbar and parts of the screen "ghost" onto other screens. I then have to drag another window across them to get them to redraw. Excel has to be restarted. It doesn't appear to be related to how long my computer's been on. Remote Desktop also seems to impact my base machine sometimes causing this. Any help is appreciated. Tag: Merge adjacent columns? Tag: 138951
  - 22
    - Sumproduct error Hi! I have a formula that work fine on a computer, but on other computer (same software installed) it return #VALUE. Formula is: =SUMPRODUCT(--(Export!$G$2:$G$100>C9);--(Export!$G$2:$G$100<D9);--(Export!$D$2:$D$100)) Can anybody help? Thanks Tag: Merge adjacent columns? Tag: 138939
  - 23
    - Number format for basis points Hello I am certainly not the first to ask but I didn't find an answer yet. Is there anyway to create a custom number format that allows to display basis points in Excel? For instance if I have a cell with the formula "=2.5%%", I would like to see "2.5bps" appearing. "0.0%%" allows to get "2.5%%" appearing. Any trick to get beyond that step? thanks in advance Charles Tag: Merge adjacent columns? Tag: 138938
  - 24
    - PIVOT TABLE ALL option Is there any way to remove the "All" option that comes in the page fields in a pivot table?? Tag: Merge adjacent columns? Tag: 138936
  - 25
    - Excel Help for Immediate Window I cannot display VBA Help for the Immediate Window using Excel 2003 under XP home. When I open Help and search for Immediate Window I get several topics. The top two, Use the Immediate Window and Immediate Window Keyboard Shortcuts do not display any information. When I click on them the machine just sits there and does nothing. All the other topics bring up a window with the topic information. Do I need to do something other than just click on either of the top two to get information displayed? Thank you. Tag: Merge adjacent columns? Tag: 138935
- Next
  - 1
    - Cell colour according to date Hi, Is there a formula that would change the cell colour if a date in a cell was out of date afetr a set number of years. Example: Cell B9 contained date 140506 I then want the cell B9 to turn red when the date reaches 2 years later 140508. Thanks in advance Jason Tag: Merge adjacent columns? Tag: 138929
  - 2
    - missing menus when I open excel the only thing I can see is the title bar and the cells. all the icons and menus are missing eg file, edit, insert etc how do I get the menus back thanks steve Tag: Merge adjacent columns? Tag: 138928
  - 3
    - Footer i have following contents need to display in excel every page. anyway that can fullfill the request. I am using excel 2003 e.g contents approval by hod approval owner approval _________ ____________ ____________ audit aprroval implemented by reviewed by ___________ ______________ ____________ Tag: Merge adjacent columns? Tag: 138926
  - 4
    - Deafult / Forced view arrangement when opening Is it possible to set a default or forced view arrangement to e.g. cascade so that and existing excel workbook automatically opens and rearranges / resizes to this mode. Most sheets I receive have been created and saved with Excel maximised and so the sheets invariably open with scroll bars running off the right and lower edges and hence have to be re-arranged Thanks Sanjay Jain Tag: Merge adjacent columns? Tag: 138925
  - 5
    - Possible to indent the height of a row? Is it possible to apply a standard size across all rows, so that all tops and bottoms of the rows will be a specified distance from the text (similar to an indent, but from top to bottom) Thanks. Tag: Merge adjacent columns? Tag: 138923
  - 6
    - FYI - MS Plugs 7 XL Flaws Just came across this article. http://blogs.zdnet.com/security/?p=943&tag=nl.e550 -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- Tag: Merge adjacent columns? Tag: 138922
  - 7
    - how to stop the Web and Reviewing Toolbars from randomly being Hello - It seems that excel is randomly displaying the Web Toolbar and Reviewing Toolbar---even though I never need to use either one of them. Does anyone happen to know how I can stop this from happening? Thanks. Tag: Merge adjacent columns? Tag: 138921
  - 8
    - Converting pdf tables into Excel files Converting pdf tables into Excel files http://www.library.mcgill.ca/edrs/services/publications/howto/PDFtoXLS/PDFtoExcel.html Tag: Merge adjacent columns? Tag: 138911
  - 9
    - How to transform a cell value that as no comma like 43534 into 435,34 Hello to ALL. I would like to know what should i use as a command or formula on Excel in order to transform a cell value that as no comma like 43534 into 435,34. Is it possible to do this in Excel? How can i do it? I use Excel 2003 SP3. Thank you in advance for any help. Best regards, Hugo Rosa Tag: Merge adjacent columns? Tag: 138906
  - 10
    - Countif using less than or greater than criteria I have a list of data in cells d11:d15. I want to be able to count how many of the data points fall within a certain numeric range (ie less than 100 but greater than 50) but I want to be able to reference a specific cell containing the criteria rather than using '100' or '50' in the formula. In my worksheet 50 is in cell I2 and 100 is in cell K2. Tag: Merge adjacent columns? Tag: 138902
  - 11
    - Simple countif syntax request Hi, I used to use Excel a lot but haven't for a few years. What is the syntax for using a countif function these days? "=countif(a1:a10,>b2)" used to do the trick I have tried using help but for some reason "=COUNTIF(B29:B40,">B23")" is not giving me the correct result, ie if I put 6.5 into cell b23 it is returning 0 not the number of cells in the range B29:B40 which are greater than 6.5 which is incredibly frustrating! Thanks, Will Tag: Merge adjacent columns? Tag: 138898
  - 12
    - Data hidden/lost in Excel 2003 spreadsheet? I have an odd situation I was hoping some of you excel experts might be able to help me with. I was sent a spreadsheet (task schedule list) that was about 25kb (only 40 rows by 8 columns). After I did some editing (adding 2 new columns and adding some information to them) and saved the file, I noticed the file size has ballooned up to 2MB! I went hunting through the file to see if had accidentally pasted a something huge from my clipboard but could find nothing. I know it is the column I added as when I delete the entire column and save the file it goes back to the original 25kb. But when I delete the rows from this column where I added data (knowingly!) the file size does not change....it remains 2MB. I manually scrolled down from row 41 to 65,536 and could see nothing but white cells. I figure there's some data hidden in there but I can't seem to figure out how to find it. Can anyone recommend a good way to hunt this down? Much appreciated. Tag: Merge adjacent columns? Tag: 138895
  - 13
    - Excel 2007 acting weird So I go into My Documents and double click an existing Excel file to open. Seems quite normal, no? This document opens, as well as a separate file "Book1". It gets rather annoying, that I've already opened the file I want. I didn't open Excel (start w/ a blank workbook) then go File>Open. Even more annoying is that I didn't make any changes to Book1 (at least that I can see), but it asks when I try to close Excel "Do you want to save?" I did have Solver installed and enabled. I've since tried disabling, but that doesn't seem to do anything. Is this normal behavior? If not, how can I stop it? TIA KenB Tag: Merge adjacent columns? Tag: 138894
  - 14
    - Is there a way to copy a cell value into a cell comment? Is there a way to copy a cell value into a cell comment? thanks! Tag: Merge adjacent columns? Tag: 138877
  - 15
    - When any cell in row 19 (eg K19) equals X I want the cell in row 25 3 Any tips will be greatly appreciated. Cheers! Tag: Merge adjacent columns? Tag: 138875
  - 16
    - Can I move comment indicator to another corner of cell? In Excel 2002, those little triangular comment indicators display in the upper right corner of their cell. I want them in the U.L. corner instead. Can I tell Excel to do that? (There is no such option in Tools / Options / View's Comments panel.) Thanks. *** Tag: Merge adjacent columns? Tag: 138870
  - 17
    - Protection from cut and paste Cell C1 is protected and has the formula A1 + B1. The users in my office sometimes cut and paste A1 and B1 to A2 and A2. After the cut and paste the formula in C1 changes to A2 + B2. What I want is for the formula to remain A1 + B1. Is there a way to protect or prevent cuts and pastes? Tag: Merge adjacent columns? Tag: 138867
  - 18
    - send mail recipient gray (inactive) Hi I am working with excel 2007 and I added "send mail recipienton" on Quick access toolbar. and now it is gray(inactive) and I can't select it. I am using Outlook 2003. I tried this kb but it didn't work for me. My registry keys same. http://support.microsoft.com/kb/918792 What can I do for this problem Thanks... Tag: Merge adjacent columns? Tag: 138860
  - 19
    - Largest non-blank sequence in row or column I'm trying to create a formula which will count the largest number of sequentially non-blank cells in a column or row. e.g. if the row had the following columns: |y|y|y|y| | |y|y|y|y|y|y| |y|y|y|y|y| the value would be 6 because it is the largest number of "y" values next to each other. Any Ideas please let me know. I'm using the formula to work out the longest number of days I do a particular task in a row. I update the spreadsheet daily and put a "y" in the row if I do that task. Tag: Merge adjacent columns? Tag: 138859
  - 20
    - Heading styles in a TOC I have created some new Heading Styles for use in a document. How would I get them to be recognized in a TOC? Are there specified Styles that ONLY will work or is there a setting to get them to be recognized? Dave French Tag: Merge adjacent columns? Tag: 138856
  - 21
    - Is this possible please Is this possible or am I asking too much of excel? If I have 254 working days in the year from D4 to D257 can it be done by a formula to work out the percentage automatically when a person is absent? It needs to know how many working days has passed in the year. Obviously up to today's date I believe it's 51 days. So, it would tell me for example that someone who has been off 10 days would have been off 5.1%. As each day passes the percentage would go down, or up if more time was taken off. It would finally tell me at the end of the year just how much time has been lost at a glance. If anyone has any ideas I would be most grateful. Bryan. Tag: Merge adjacent columns? Tag: 138855
  - 22
    - Excel 2002 parameter query returns some blanks instead of data Hello and thanks up front... (I'm going bonkers), It's invoice time, so in my "Job Records" file, I'm using a parameter query (Excel 02, Microsoft Query) to return only those records that occur in one specified month. In the original Excel "Job Records" file on which the query is based, one column of data, labeled "PO", lists purchase order names (e.g. "VBL" for a verbal Purchase Order) or numbers (e.g. "102509"). The column is automatically formatted by Excel as "General", and I just let it ride. A second column of data, labeled "Funding Entity" lists codes - some codes are letters , others are numbers, (e.g. "GF" for Gen. Fund, "21" for 21st Fund) all formatted as "Text". When I execute the query, everything works great (the correct records, selected by month, are returned) except that the cells containing numbers formatted as "General", when returned in the "PO" column, are skipped so the resulting cell is just blank. And in the resulting "Funding Entity" column, cells containing letters (e.g. "GF") end up blank and all those containing numbers formatted as test, e.g. "21", show up just fine. So, I end up with a "PO" column containing all the entries that were "VBL", but only blanks where the entries that are numbers (formatted as "General") should be and a "Funding Entity" column containing only "21", but no "GF"s. I tried (feebly) to change the numbers formatting to "Numbers", but it didn't work. Anyone know where I went wrong? Tag: Merge adjacent columns? Tag: 138854
  - 23
    - Get Column Header from Match in a Array? Here's what I am trying to do. I have a table of date, with the column names in Row 1, Column B-J. The Data from B2:J11 is dates. On a second sheet, I have the dates listed chronologically, I'd like to use a formula to take at the date in the second sheet, and look at the array on the first sheet and tell me what column it is in - or give me the text value from row 1 in that column. Tag: Merge adjacent columns? Tag: 138852
  - 24
    - =?Utf-8?Q?Loosing_formula_when_changing_ro?= Iâ??m stymied and could use some help. I have a file that contains data in Sheet1 A1:A3 with values a,b,c. In Sheet2 B1:B3 I reference Sheet1â??s data with =Sheet1!A1 and so on. In Sheet2 if I try change the row reference from A1 to A2 I donâ??t get the value, I get the formula displayed =Sheet1!A2. The problem is that I have 2 columns like this and one works with reference changes the other doesnâ??t. I have checked cell formatting and option settings in all cells and they are all identical. The only clue Iâ??ve seen is that before the attempted change I can still do a precedent trace but after changing the row # to a valid row the trace indicates that the cell doesnâ??t â??contain a formula with a valid referenceâ??. The formula/link is getting clobbered, but I can find no settings that would effect that and would appreciate any hints. Tag: Merge adjacent columns? Tag: 138848
  - 25
    - Automatically add calendar events? Using the powershell, is there a way to add calendar events to specific mailboxes? Our vacation time request system is a home grown web-based application. We'd like to configure it so that once the vacation time has been approved, the requesters Outlook calendar would then automatically be populated with "out of office" entries for the days off they requested. Thanks in advance! Tag: Merge adjacent columns? Tag: 138847

Using Excel 2007, I have three text columns right next to each other.
Can I merge these three columns into one? Thanks.

Re: Merge adjacent columns? by Max

Max
Sat Mar 15 07:31:10 CDT 2008

In D1, copied down: =TRIM(A1&" "&B1&" "&C1)
where cols A to C are the 3 text cols, data in row1 down
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Rick" <rick@invalid.net> wrote in message
news:epLE4BohIHA.200@TK2MSFTNGP02.phx.gbl...
> Using Excel 2007, I have three text columns right next to each other. Can
> I merge these three columns into one? Thanks.

Top