counting characters in a cell

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
    - Pasting Cells with Filter on When I am using Auto - Filter and I copy a selection of cells and try to paste them into another column, it appears to ignore the filter and pastes the rows as if the filter weren't turned on. So, instead of the data only going only into the visible rows where it belongs, it goes into the rows hidden by the filter. Is there a way around this? Tag: counting characters in a cell Tag: 70049
  - 2
    - getting first few characters of a cell in another one I know there's a simple way of doing this, but I can't remember how at the moment. I need to have a cell return the first 3 characters of another cell. Example A1 B1 Example Exa Could someone please remind me how to do this? Thanks. Tag: counting characters in a cell Tag: 70044
  - 3
    - Tab key Hi, How to move 2 cells to the right by pressing the Tab key. Thanks Tag: counting characters in a cell Tag: 70038
  - 4
    - Transforming Data Consider the the below example: Sheet1: (This is what I have) A B C D E F 1 x x x y y y 2 x x x y y y 3 x x x y y y 4 x x x y y y 5 x x x y y y *Sheet2: (This is how I want it to be) A B C 1 x x x 2 y y y 3 x x x 4 y y y 5 x x x 6 y y y 7 x x x 8 y y y 9 x x x 10 y y y * Sheet2 links with Sheet1 Hope this illustrates my problem.....and I am sure you must have some solution for it. Thank you, Tag: counting characters in a cell Tag: 70037
  - 5
    - Excel Continous pagenumbering Can anybody help me with the following issue: I have an Excel workbook with several filled sheets, when printint eac sheet may contain more than one page. When adding pagenumers and selecting a group of sheets, the pagenumbe always starts with 1 for each sheet. I would like to number continously: E.g.: Sheet 1 contains 2 pages Sheet 2 contains 1 page Sheet 3 contains 4 pages When grouping and adding current page Nr /total number op pages in th footer the total shows page x / 7 thus: 1/7, 2/7, 1/7, 1/7,2/7, 3/7, 4/7 instead of 1/7 through 7/7 Any ideas? Thank You, Hans : -- hhall ----------------------------------------------------------------------- hhalle's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2082 View this thread: http://www.excelforum.com/showthread.php?threadid=39804 Tag: counting characters in a cell Tag: 70031
  - 6
    - validation column Hi all, I have a problem to make validation to prevent duplication value in column. Suppose I have arrays of data in column A (Employee ID) that contains values, i want to no duplication value when i entering new data. If i entered the same value as previous row then error message should be alert. Any body can help what should the formula function applied. Thanks in advance. cheers. Tag: counting characters in a cell Tag: 70029
  - 7
    - How can I use VBA ADO to check if a table exists in an Access DB? Hi! If I aready have an access DB called c:\temp\MyDb.mdb, is there any way that I can use ADO to check if a table exists in this database? Thanks, Aijun. -- Ai_Jun_Zhang ------------------------------------------------------------------------ Ai_Jun_Zhang's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=25474 View this thread: http://www.excelforum.com/showthread.php?threadid=397998 Tag: counting characters in a cell Tag: 70027
  - 8
    - Tracking calculation progress Hi, I am troubleshooting why a spreadsheet is taking over 30 minutes to calculate cells using Excel 2003 when a previous version of the same spreadsheet was taking a few minutes. Is there a way to know what is being calculated when the progress bar gets stuck at 75%? The spreadsheet is quite complex (over 20 Mbytes with various models and formulas) and I am not sure where to start. Thank you for your help. C Tag: counting characters in a cell Tag: 70021
  - 9
    - How do I do this? I'll make this as simple as I can (for my sake :-) ,not yours ) Lets say I have a workbook with a sheet for each month. Each months sheet has four colums. DATE, NAME, CHECK NUMBER, AMOUNT Now I want to set up 13th worksheet. I want to have on this worksheet a list of one particular name and all corresponding check numbers and amounts each time this name is used. So basically I want to search for a particular payee and return the check number and amount each time we send a check to this payee. I want to end up with one sheet with a list of however many entries that particular payee is used. I hope this is enough info...and thanks in advance for any help. Tag: counting characters in a cell Tag: 70020
  - 10
    - XIRR in Excel 2003 There are two common situations: 1. Place an order to buy $10000 of a mutual fund. Due to fractional shares, and rounding, it is not uncommon to see value on that same day be $9999.99. 2. Purchase a stock at, say, 11:00 A.M. and then value may be lower later that same day, e.g., at market close or in after hours market. XIRR, in Excel 2003, handles these cases if the value is >= the purchase price, but not if the value is < the purchase price, in which case a NUM error is displayed. Has this been fixed in Excel 2005? Tag: counting characters in a cell Tag: 70016
  - 11
    - setting print area for multiple worksheets at once Hello - Looking for a way to set the print area on a large number of simiarly formatted worksheets at once. Ideally want to incorporate it into a macro that does some other basic stuff as well. Thanks for any suggestions! -- annabel ------------------------------------------------------------------------ annabel's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=26520 View this thread: http://www.excelforum.com/showthread.php?threadid=397879 Tag: counting characters in a cell Tag: 70011
  - 12
    - Offset from refernce in other cell I need to point a cell to another as an offset from a reference. For example, cell A1 formula is =G10 I want cell A2 formula to be =G20 I need this to be dynamic as I need to drag it along the whole spreadsheet. I can't seem to get this to work using the offset or indirect functions. Any ideas? Jonathan Blitz AnyKey Limited Israel Tag: counting characters in a cell Tag: 70007
  - 13
    - 60 GB IPOD deal found I just completed this offer for a 60 gb photo ipod and it is awesome! My friend got one from it and he is waving it in my face and taunting me! Anyways, all you have to do is complete a promotion offer and cancel it before the 30 days trial is up and then get 8 referrals. I recommend doing the rhapsody promotion because it is only $0.99 and you get instant credit towards your ipod. It is so cool. Check it out. http://www.freephotoiPods.com/?r=21360900 Tag: counting characters in a cell Tag: 70006
  - 14
    - Excel 2002 Pivot Table #DIV/0! Keep getting this error message in a percentage data field. The fields that are used are "calculated" data fields and not from the excel list. Tag: counting characters in a cell Tag: 69999
  - 15
    - spelling Am working on a workbook in Excel and trying to check the spelling, i gives the following message: Do u want to continue checking at the begging of the sheet Yes/No I choose Yes, then it gives me the following message The spelling check is complete for the entire sheet But it did not check the spelling, although there are mistakes, what t do? any ideas. Thank u in adv -- Geo ----------------------------------------------------------------------- Geor's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2347 View this thread: http://www.excelforum.com/showthread.php?threadid=39781 Tag: counting characters in a cell Tag: 69997
  - 16
    - "locked for editing" Excel XP I was working on a spreadsheet for a friend, and kept getting the "locked for editing" error. The friend is on a standalone PC, and I was saving my copy to the local hard drive. We are both getting this error, even when we create new files from the old one. Neither one of us is working on a network drive, and my friend isn't even on a network. Any ideas how to fix this other than constant rebooting? TIA, Doreen Tag: counting characters in a cell Tag: 69994
  - 17
    - title row Hi I have an excel of about 150 rows the first row is a title when I print the title is on the first page but not the others - can I get it to auto add to each page ? David Tag: counting characters in a cell Tag: 69993
  - 18
    - Countif problem Hi I have an excel and I want to count letters - one of the things I am counting is the number of A* where A* is the actual data. In countif excel is treating the * as a wildcard and is counting As too - I only want it to count "A*" - any ideas ? David Tag: counting characters in a cell Tag: 69990
  - 19
    - Combined Functions Hello, I am trying to streamline my work. I am trying to apply two functions to the same data at once. Is this possible? 1. PROPER(A1) 2. TRIM(A1) How would I combine the above two and have the result appear in one cell? Thanks, -- fncuis ------------------------------------------------------------------------ fncuis's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=26466 View this thread: http://www.excelforum.com/showthread.php?threadid=397792 Tag: counting characters in a cell Tag: 69987
  - 20
    - What tool to use to customise the look of portal server? Hi all I usually use Front page to create a website / web page. Now I just install Portal Server 2003 and wish to customise the look and feel of the site. It look me ages to manage to have the search works (re-install the system about 5 times!) Now I want to customise the look but I am not sure whether using front page is the way to do as I saw some posts which some people mentioned the malfunctions of the search after using Frontpage to customise their page. My questions are 1. Is this the case? 2. If so what could be the alternative package to use to customise the page in Portal Server? Any recommendations will be much appreciated Thanks Peddie Tag: counting characters in a cell Tag: 69983
  - 21
    - Filesize Hi, I have a spreadsheet that contains lists of data (just data, no external links), over the years of data collection this has reached 96meg, I tried to make the file smaller by saving a copy and deleting current data and calling this copy 'history.xls', I then deleted the historic tabs from the working version and saved it. The problem is that, despite deleting the old data, the file still shows as being 96meg. I am presuming that the data is still in existance 'behind the scenes' how can I update the file without copying the current tabs into a new workbook? Darren Tag: counting characters in a cell Tag: 69982
  - 22
    - 60 GB IPOD deal found I just completed this offer for a 60 gb photo ipod and it is awesome! My friend got one from it and he is waving it in my face and taunting me! Anyways, all you have to do is complete a promotion offer and cancel it before the 30 days trial is up and then get 8 referrals. It is so cool. Check it out. http://www.freephotoiPods.com/?r=21360900 Tag: counting characters in a cell Tag: 69981
  - 23
    - MailMerge Problem This *might* be a Word problem, but I have a feeling its not. Excel XP, Word XP. I'm merging data from Excel into Word. I have cells that have data like: 101, 107, 109, etc and they merge fine. However, when I get to the cells with data like : QB101, QB107, QB109 I get a "0" in the field instead of my data. The column is formatted as text. When I do a =ISTEXT I get a "true" response, yet I still get a "0". Any idea what I'm doing wrong, or what I need to fix/change? Thanks in advance for your help! Doreen Tag: counting characters in a cell Tag: 69980
  - 24
    - Help with a schedule I need some help with a work schedule done in Excel. The schedule is not very complex; however, when multiple changes to the schedule are made for vacations ect, it becomes a garbled mess & I find that some problems arise for me to be able to mentally determine how many people are working during a given time when it's in text format. I think it would be much easier to see in a chart if I was able to convert the text into one. (A page of our current schedule can be downloaded for reference at http://homepage.mac.com/WebObjects/FileSharing.woa/wa/schedule.jpg.jpg-bi nhex.hqx?a=downloadFile&user=gadgetman&path=.Pictures/schedule.jpg) If there's a way to do it, I'd like to be able to chart a 24hr period (6am one day to 6am the next day for example) and be able to see who's working during that day with the start of the bars of the chart showing the start time of the person's shift and the end of the bars of the chart showing the stop time of the shift. I don't know if that makes sense. I've tried to give an example of what I mean here: http://homepage.mac.com/WebObjects/FileSharing.woa/wa/24hr_Chart.jpg.jpg- binhex.hqx?a=downloadFile&user=gadgetman&path=.Pictures/24hr%20Chart.jpg Any and all help would be appreciated! Thanks! PS: if the above links for the sample files dont work, the sample files can be seen/downloaded here: http://homepage.mac.com/gadgetman/Schedule/FileSharing9.html Tag: counting characters in a cell Tag: 69979
  - 25
    - Open Two Instances of Excel 2K Hi All, I used to be able to open two instances of Excel such that I could look at two workbooks at the same time with dual-monitors running. Anyone know how I can get this kind of setup back? Thanks & Ciao, Tony Tag: counting characters in a cell Tag: 69978
- Next
  - 1
    - Excel 2002 Check for duplicates Sorted an Excel list for a Pivot Table by Check number for the years 1997-2005. Any easy way to check for duplicates w/o getting into VBA? Check# 7894 7895 7895 7896 Tag: counting characters in a cell Tag: 69974
  - 2
    - How to change *defaults* for importing Tab-delimited text file into Excel2002 - How to I change the default setting when importing a .txt file? I spend a lot of time converting Excel (Office 2002) files into HTML. The quickest way to clear off all the Microsoft formatting crud seems to be to save as a tab delimited .TXT file. This works well but it is extremely irritating that having saved as "tab delimited text" from Excel, that the same piece of software cant recognise its own file when you reopen it! It seems to default to Delimited and file origin "932: Japanese (Shift-JIS)" whereas what I want is file origin of: "1252 : Western European (Window)". However this requires clicking on the drop-down list (which always takes a while to fill up for some reason) and the scrolling to the bottom of the list...! How can I get Excel to recognise the file-type of what it has just saved?! Ship Tag: counting characters in a cell Tag: 69969
  - 3
    - Help with Lookup formula I have a three columns of data, column A has part number, column B has cost, column C has company name. What I would like to be able to do is for a formula to lookup 'company1' and give me a total cost of the parts. Is this an easy thing to do? Tag: counting characters in a cell Tag: 69965
  - 4
    - Extracting data from pivot tables Hi, I am creating a chart using data from various pivot tables. In order to do this I am creating a data table using data extracted from the data tables upon which I will base my chart. In order to take the data from the pivot table I create a formula by typing = then going to the pivot table cell that I want. So far so good... however, is there a way that I can drag this formula across to pick up the next cell and the next etc (just like if you were doing a formula within excel) rather than having to create a new formula for each cell that I want to pickup? Tag: counting characters in a cell Tag: 69964
  - 5
    - footer Hi, Is it possible that if user creates new documents in word or excel, automatically (date, name, paths and etc) to be added as footer or is it possible somehow to make domainwide via AD? Regards, Ramin Thanks, Ramin Tag: counting characters in a cell Tag: 69958
  - 6
    - IF conditional statements Hi, It's my understanding that I can nest up to seven levels of the IF functions within one formula. My question is how does one nest over seven levels? Below is the actual code without adding the additional IF statements. =IF(D8=" "," ",IF(D8=$L$81 Then +Insured!$G$38-Worksheets!D45,IF(D8=$L$82,+Insured!$G$40-Worksheets!D45,IF(D8=$L$83,+Insured!$G$42-Worksheets!D45,IF(D8=$L$84,+Insured!$G$44-Worksheets!D45))))) Here's is an example of over sevel levels where I like to add to the cell, but again I cannot because Excel only nest up to seven levels. =IF(D8=" "," , IF(D8=$L$81,+Insured!$G$38-Worksheets!D45, IF(D8=$L$82,+Insured!$G$40-Worksheets!D45, IF(D8=$L$83,+Insured!$G$42-Worksheets!D45, IF(D8=$L$84,+Insured!$G$44-Worksheets!D45, IF(D8=$L$85,+Insured!$G$46-Worksheets!D45, IF(D8=$L$86,+Insured!$G$48-Worksheets!D45, IF(D8=$L$87,+Insured!$G$50-Worksheets!D45, IF(D8=$L$88,+Insured!$G$52-Worksheets!D45, IF(D8=$L$89,+Insured!$G$54-Worksheets!D45, IF(D8=$L$90,+Insured!$G$56-Worksheets!D45))))))))))) Any tips will be appreciated. Thank you. Tag: counting characters in a cell Tag: 69955
  - 7
    - Need rows in Column A removed if... Hi There, I have rows of text strings in Column A and in Column B. I need rows in Column A removed if they partially or exactly match with text strings in any Column B row. Your input is appreciated! Alexa Tag: counting characters in a cell Tag: 69950
  - 8
    - Excel: numbers in cells get divided by 100: all spreadsheets ... Hi, I have a strange problem that I don't know how to fix. I'm using Excel 2000. Something happened recently and I'm not sure why or how, but in every spreadsheet I have if one enters a number into a cell the number will be divided by 100 automatically. This happens in all my spreadsheets, so I thought Excel might have been corrupted somehow. I have reloaded Excel, actually "Office 2000", three times now and, also, I tried to delete any files that I thought might be related to Excel (before reloading again) but the problem remains. I've looked and tested all the menu items but I have not come upon a feature that causes the problem (or solves it). Could it be that every Excel file I have has been modified somehow so they all have this problem that I don't know how to get rid of? I'm almost at my wits end with this. I'm using MS Windows Me. Any ideas to help would be greatly appreciated! Al Tag: counting characters in a cell Tag: 69944
  - 9
    - Pivor Table Data Field - "Show aftering Hide" This is a multi-part message in MIME format. ------=_NextPart_000_000C_01C5A644.DE8D0D20 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I have tried to "show" a data field after using "hide" in field = settings. How can I make this reappear? Not using Field drop down = option. The fields orgin is from the excel list and not a calculated = fields. ------=_NextPart_000_000C_01C5A644.DE8D0D20 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.2900.2722" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>I have tried to "show" a data field = after using=20 "hide" in field settings.  How can I make this reappear?  Not = using=20 Field drop down option.  The fields orgin is from the excel list = and not a=20 calculated fields.</FONT></DIV></BODY></HTML> ------=_NextPart_000_000C_01C5A644.DE8D0D20-- Tag: counting characters in a cell Tag: 69939
  - 10
    - error/please help I formatted my PC & did a clean install of Windows Xp PRO when i opened Excell i get this error message. Microsoft visual basic COMPILE ERROR IN VISUAL MODULE:AUTO EXEC NEWThe help files tell me to unprotect,BUT there is no unprotect option in tools/protection. I uninstalled Excel,bebooted & installed Excell. Still get the error Tag: counting characters in a cell Tag: 69938
  - 11
    - Error please help I formatted my PC & did a clean install of Windows Xp PRO when i opened Excell i get this error message. Microsoft visual basic COMPILE ERROR IN VISUAL MODULE:AUTO EXEC NEWThe help files tell me to unprotect,BUT there is no unprotect option in tools/protection. I uninstalled Excel,bebooted & installed Excell. Still get the error Tag: counting characters in a cell Tag: 69937
  - 12
    - print pre-printed forms Is the any way to use excel to print pre-printed forms ( invoices , etc ) after all datas are entered? Is there any way to design a template for that ? Tks !! Osvaldo Tag: counting characters in a cell Tag: 69935
  - 13
    - Deleting Sheets Based on Name Ive got a macro which makes a large number of sheets with information in them.... Ive then got another macro which gets all the information from those sheets.... the problem is... im then left with all the sheets.. and I really want to delete them..... Is there anyway to make a macro which would let me delete sheets.. based on their name..... all the ones i want to delete are called "cats (104)" or "cats (105)" etc etc..... there is one called "cats" which i want to keep.... so basically If it could someonie delete based on the term "cats (" any ideas? Tag: counting characters in a cell Tag: 69931
  - 14
    - Max valve for each customer Hello, I am the new member here and would like to seek your prof. help in Excel. Thank you. Given: _A1:_Customer_ A2: JOE A3: TOM A4: JOE A5: PETER A6: JOE _B1:_Purchase_ B2: $11 B3: $22 B4: $25 B5: $20 B6: $11.5 How can I have gotten the max pruchase for _each__ customer? Let's say, Joe have total 3 records in the sheet (A2, A4 & A6) and the purchase are $11 (B2), $25 (B4)& $11.5 (B6) respectively. What I need is to sort out the max purchase value of JOE, i.e. $25. Thanks all! -- syscan ------------------------------------------------------------------------ syscan's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=26486 View this thread: http://www.excelforum.com/showthread.php?threadid=397545 Tag: counting characters in a cell Tag: 69929
  - 15
    - Help with a formula please. In column "A" I have about 400 file names with each path, for example: D:\Folio_02\AL605_02.xls Each file contains a value named "ATT" and another named "XBB". I need to get these values in adjoining columns. I've tried every variation of the following I can think of without success: A1&"!"&ATT None have worked. I'm sure I have done this before but can't remember and can't find any of my old files with an example. Please help. Jim Tag: counting characters in a cell Tag: 69915
  - 16
    - Viewing Zero's In Cells Hi, I am entering telephone numbers into a spreadsheet, and as these all start with a zero. I enter a ' preceeding the zero, but this still displays a triangle in the top left of the cell. Is there any way I can enter a cell beginning with a zero without the triangle showing? Thanks Greg Matthews Tag: counting characters in a cell Tag: 69909
  - 17
    - Help counting items please Having a bit of trouble counting items on the following example: A B 1 Apples Pears Bananas Green 2 Peaches Apples Grapes Yellow 3 Pears Oranges Tomato Green 4 Corn Squash Apples Green I'd like to use a formula to count how many cells in column A contain "Apples", while at the same time column B contains "Green" I can do a conditional sum to find out how many cells in column A contain "Apples Pears Bananas" and column B "Green", but can anyone tell me how to look for just the one word within a cell, when the word position could be anywhere within the cell, and conditionally sum it with column B? Many thanks in advance! Tag: counting characters in a cell Tag: 69899
  - 18
    - message box? This will be very basic for you guys, I want to create a message box when somebody tries to change any part of my workbook, with some kind of "copyright" notice. I presume I protect the workbook first, then enter some kind of code. Anybody help with this please? Tag: counting characters in a cell Tag: 69896
  - 19
    - Help! I'm completely clueless w/ Excel! Hello -- Please be kind! I'm new to these boards and I'm miserably clueless about Excel. I need some help with my Statistics homework so if you're kind and/or valiant and/or bored enough to hand-hold a complete idiot through the process, I'll be so absolutely grateful! :) Okay, so in this assignment I have a spreadsheet file: Column A has a series of various numbers: A1 has 10; A2 has 30; A3 has 5; ..and on and on it goes. 1) In this assignment, I have to somehow make column B bring out the percentage difference from an arbitrary number (in this case 20) to the numbers in the A column. For instance, since A1 is 10; B1 will have to be -50% (since 10 is a 50% decrease of 20). And for B2, since A2 is 30, B2 should generate a 50% in its cell (since 30 is a 50% increase from 20). So how do I make Excel automatically generate the percentage differences for rest of the B column? 2) So after the B column gets filled out...is there a way for Excel to determine the probability that a certain percentage will occur, judging from what's spat out into the B column? For instance, one of the questions on my assignment asks for the probability that -45% will happen, judging from what's generated in column B... So how I do I input a formula/code for Excel to look through what's in the B column and determine how likely -45% (or any other percentage) happens? I know there're many ways Excel can figure out probabilities -- so if you'd be so kind to just hand-hold me through a basic approach, then mention any other methods that may yield better answers, I can look them up accordingly.) (Please don't be mean! If possible, please try to explain all this as gently and as "step-by-step" as possible -- you know, as if I'm a complete dunce, because, well, I am. :( ) Thank you so much for any help and insight you can provide! :) -- Ayn00 ------------------------------------------------------------------------ Ayn00's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=26476 View this thread: http://www.excelforum.com/showthread.php?threadid=397447 Tag: counting characters in a cell Tag: 69895
  - 20
    - Worksheets I have an excel book with several charts. I need to know how I can create a pivot table or VBA formula, that will allow my manager to select a certain BRANCH from a dropdown list and display its corresponding chart? -- tdiaz ------------------------------------------------------------------------ tdiaz's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=26468 View this thread: http://www.excelforum.com/showthread.php?threadid=397375 Tag: counting characters in a cell Tag: 69880
  - 21
    - Serious printing /cache problem I have an e-mail with an excel report of inventory i've sold. When I choose to open the e-mail (double clicking in outlook) it displays fine but when I print it, it prints a REALLY old version of that document... and I have no clue where it's getting it. The e-mail they send always has the same file name. Yet, even if I save the file to my desktop, open it from there the contents of the file looks just fine, but when I print, it prints some old information from a july version. Please help. Tag: counting characters in a cell Tag: 69876
  - 22
    - how to print the worksheet name somewhere on the printed page ? Hello there I was wondering how to print the worksheet name somewhere on the printed page ? Thanks Tag: counting characters in a cell Tag: 69875
  - 23
    - next office version...when? Does anyone know if there is going to be a next version of Office soon? Like possibly next year when Longhorn is expected out? Peggy Tag: counting characters in a cell Tag: 69868
  - 24
    - Entering text that start with Zero ? How do I enter text that starts with a zero and have the cell show the zero. Example : 0256 0891 0188 etc Thank You. Tag: counting characters in a cell Tag: 69849
  - 25
    - 1 user? If I buy the latest version of Excel and/or Word, and it says it's for 1 user, does that mean that if I have a desktop and a laptop I can only install it on one computer? TIA Peggy Tag: counting characters in a cell Tag: 69848

How can I have cell B2 return the number of characters in cell B1?

Thanks.

Re: counting characters in a cell by Dave

Dave
Tue Aug 23 09:06:48 CDT 2005

=len(b1)

Glenn wrote:
>
> How can I have cell B2 return the number of characters in cell B1?
>
> Thanks.

--

Dave Peterson

Top

Re: counting characters in a cell by Lewis

Lewis
Tue Aug 23 09:10:31 CDT 2005

Try typing this in B2:
= LEN(B1)

"Glenn" <nospam@yahoo.com> wrote in message
news:ul1xHt%23pFHA.2628@TK2MSFTNGP10.phx.gbl...
> How can I have cell B2 return the number of characters in cell B1?
>
> Thanks.
>
>

Top

Re: counting characters in a cell by RagDyeR

RagDyeR
Tue Aug 23 09:40:56 CDT 2005

Do you consider <space> as a character?

If you *don't*, this is number of characters, not counting spaces:

=LEN(SUBSTITUTE(B1," ",""))

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

"Glenn" <nospam@yahoo.com> wrote in message
news:ul1xHt%23pFHA.2628@TK2MSFTNGP10.phx.gbl...
How can I have cell B2 return the number of characters in cell B1?

Thanks.

Top