| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: How to eliminate space within a cell and count items?
Dear Sir,
1. May I know how to eliminate the spacing within a cell as follows : Before eliminating After eliminating AAB 8426 AAB8426 AAC 6542 AAC6542 2. Also in Excel 2002, the when a block of cell containing numbers is highlighted, it sum total appears at the right hand bottom of the screen without displaying the number of items added. Is there anyway I can customized this function to show n items when the cells are highlighted ? or is there any other keyboard shortcut of doing this ? Can the worksheet count the number of text items (n) highlighted in a column ? For example : Column A ABC2111 ACC2112 ACD2145 , n =3 Thanks Low -- A36B58K641 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002: How to eliminate space within a cell and count items?
You could use Edit | replace to change the actual data
or to get the required data in a new cell use =SUBSTITUTE(A1," ","") that double-quotes with and without a space between them best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Mr. Low" wrote in message ... Dear Sir, 1. May I know how to eliminate the spacing within a cell as follows : Before eliminating After eliminating AAB 8426 AAB8426 AAC 6542 AAC6542 2. Also in Excel 2002, the when a block of cell containing numbers is highlighted, it sum total appears at the right hand bottom of the screen without displaying the number of items added. Is there anyway I can customized this function to show n items when the cells are highlighted ? or is there any other keyboard shortcut of doing this ? Can the worksheet count the number of text items (n) highlighted in a column ? For example : Column A ABC2111 ACC2112 ACD2145 , n =3 Thanks Low -- A36B58K641 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002: How to eliminate space within a cell and count ite
Question 2:
Right click on the status bar (bottom edge of Excel window), select Count from the local menu! Regards, Stefi €˛Bernard Liengme€¯ ezt Ć*rta: You could use Edit | replace to change the actual data or to get the required data in a new cell use =SUBSTITUTE(A1," ","") that double-quotes with and without a space between them best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Mr. Low" wrote in message ... Dear Sir, 1. May I know how to eliminate the spacing within a cell as follows : Before eliminating After eliminating AAB 8426 AAB8426 AAC 6542 AAC6542 2. Also in Excel 2002, the when a block of cell containing numbers is highlighted, it sum total appears at the right hand bottom of the screen without displaying the number of items added. Is there anyway I can customized this function to show n items when the cells are highlighted ? or is there any other keyboard shortcut of doing this ? Can the worksheet count the number of text items (n) highlighted in a column ? For example : Column A ABC2111 ACC2112 ACD2145 , n =3 Thanks Low -- A36B58K641 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002: How to eliminate space within a cell and count items?
For 2. Right-click on the status bar and select "count" from the options. This will count all cells selected, not just text cells. Count Nums will count all cells with numbers. Gord Dibben MS Excel MVP On Thu, 23 Nov 2006 06:32:01 -0800, Mr. Low wrote: Dear Sir, 1. May I know how to eliminate the spacing within a cell as follows : Before eliminating After eliminating AAB 8426 AAB8426 AAC 6542 AAC6542 2. Also in Excel 2002, the when a block of cell containing numbers is highlighted, it sum total appears at the right hand bottom of the screen without displaying the number of items added. Is there anyway I can customized this function to show n items when the cells are highlighted ? or is there any other keyboard shortcut of doing this ? Can the worksheet count the number of text items (n) highlighted in a column ? For example : Column A ABC2111 ACC2112 ACD2145 , n =3 Thanks Low |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002: How to eliminate space within a cell and count ite
Hello Bernard,
Your =SUSTITUTE( ) formula works very well. It is goinfg to be very helpful for my daily tasks in the future. Many thanks Low -- A36B58K641 "Bernard Liengme" wrote: You could use Edit | replace to change the actual data or to get the required data in a new cell use =SUBSTITUTE(A1," ","") that double-quotes with and without a space between them best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Mr. Low" wrote in message ... Dear Sir, 1. May I know how to eliminate the spacing within a cell as follows : Before eliminating After eliminating AAB 8426 AAB8426 AAC 6542 AAC6542 2. Also in Excel 2002, the when a block of cell containing numbers is highlighted, it sum total appears at the right hand bottom of the screen without displaying the number of items added. Is there anyway I can customized this function to show n items when the cells are highlighted ? or is there any other keyboard shortcut of doing this ? Can the worksheet count the number of text items (n) highlighted in a column ? For example : Column A ABC2111 ACC2112 ACD2145 , n =3 Thanks Low -- A36B58K641 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002: How to eliminate space within a cell and count ite
Hello Stefi,
Many thanks for your info. It is going to be very helpful for my daily office work in the future. Kind Regards Low -- A36B58K641 "Stefi" wrote: Question 2: Right click on the status bar (bottom edge of Excel window), select Count from the local menu! Regards, Stefi €˛Bernard Liengme€¯ ezt Ć*rta: You could use Edit | replace to change the actual data or to get the required data in a new cell use =SUBSTITUTE(A1," ","") that double-quotes with and without a space between them best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Mr. Low" wrote in message ... Dear Sir, 1. May I know how to eliminate the spacing within a cell as follows : Before eliminating After eliminating AAB 8426 AAB8426 AAC 6542 AAC6542 2. Also in Excel 2002, the when a block of cell containing numbers is highlighted, it sum total appears at the right hand bottom of the screen without displaying the number of items added. Is there anyway I can customized this function to show n items when the cells are highlighted ? or is there any other keyboard shortcut of doing this ? Can the worksheet count the number of text items (n) highlighted in a column ? For example : Column A ABC2111 ACC2112 ACD2145 , n =3 Thanks Low -- A36B58K641 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2002: How to eliminate space within a cell and count ite
Hello Gord,
Many thanks for your information. It is going to be very helpful for my daily office work in the future. Kind Regards Low -- A36B58K641 "Gord Dibben" wrote: For 2. Right-click on the status bar and select "count" from the options. This will count all cells selected, not just text cells. Count Nums will count all cells with numbers. Gord Dibben MS Excel MVP On Thu, 23 Nov 2006 06:32:01 -0800, Mr. Low wrote: Dear Sir, 1. May I know how to eliminate the spacing within a cell as follows : Before eliminating After eliminating AAB 8426 AAB8426 AAC 6542 AAC6542 2. Also in Excel 2002, the when a block of cell containing numbers is highlighted, it sum total appears at the right hand bottom of the screen without displaying the number of items added. Is there anyway I can customized this function to show n items when the cells are highlighted ? or is there any other keyboard shortcut of doing this ? Can the worksheet count the number of text items (n) highlighted in a column ? For example : Column A ABC2111 ACC2112 ACD2145 , n =3 Thanks Low |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I perfom a character count in a single cell in Excel? | New Users to Excel | |||
| A formula to count characters in an Excel cell? | Excel Worksheet Functions | |||
| Excel: How do I count the number of pictures in an excel cell? | Excel Discussion (Misc queries) | |||
| Excel, how to count every 4th cell in column to see if occupied? | Excel Worksheet Functions | |||
| Excel: How to return count for each cell within date range criter. | Excel Worksheet Functions | |||
Linear Mode
