Count occurance of a leter in a text string
 

Needing to make a simple billboard sign making sheet.

The operator would enter the sign's current text and in another
cell enter the new text.

The sheet would show the number of each letter used in the current
sign and compare to that needed in the new sign and show those
letters need to complete the new sign.

That way the workers would only have to carry the necessary letters
up the ladder to complete the new billboard.

Thanks for any help you can provide.


--
--------------------------------- --- -- -
Posted with NewsLeecher v3.95 Beta 1
Web @ http://www.newsleecher.com/?usenet
------------------- ----- ---- -- -

Count occurance of a leter in a text string
 

Let's assume A1 contains the text of the current sign and B1 contains the
text of the new sign.

Enter a couple of column headers in say I1 and J1:

I1 = Current
J1 = New

Enter the letters A, B, C, D, .... Z in cells H2:H27

Enter this formula in I2:

=LEN(A$1)-LEN(SUBSTITUTE(UPPER(A$1),$H2,""))

Copy across to J2

If the result in column J is greater than the result in column I you need
the difference. You can put another formula in column K to get the
difference but you can probably figure out how to do that.


--
Biff
Microsoft Excel MVP


"justaman" wrote in message
...
Needing to make a simple billboard sign making sheet.

The operator would enter the sign's current text and in another
cell enter the new text.

The sheet would show the number of each letter used in the current
sign and compare to that needed in the new sign and show those
letters need to complete the new sign.

That way the workers would only have to carry the necessary letters
up the ladder to complete the new billboard.

Thanks for any help you can provide.


--
--------------------------------- --- -- -
Posted with NewsLeecher v3.95 Beta 1
Web @ http://www.newsleecher.com/?usenet
------------------- ----- ---- -- -

Count occurance of a leter in a text string
 

Left out something!

Enter this formula in I2:
Copy across to J2

Then select both I2 and J2 and copy down to row 27.

--
Biff
Microsoft Excel MVP


"T. Valko" wrote in message
...
Let's assume A1 contains the text of the current sign and B1 contains the
text of the new sign.

Enter a couple of column headers in say I1 and J1:

I1 = Current
J1 = New

Enter the letters A, B, C, D, .... Z in cells H2:H27

Enter this formula in I2:

=LEN(A$1)-LEN(SUBSTITUTE(UPPER(A$1),$H2,""))

Copy across to J2

If the result in column J is greater than the result in column I you need
the difference. You can put another formula in column K to get the
difference but you can probably figure out how to do that.


--
Biff
Microsoft Excel MVP


"justaman" wrote in message
...
Needing to make a simple billboard sign making sheet.

The operator would enter the sign's current text and in another
cell enter the new text.

The sheet would show the number of each letter used in the current
sign and compare to that needed in the new sign and show those
letters need to complete the new sign.

That way the workers would only have to carry the necessary letters
up the ladder to complete the new billboard.

Thanks for any help you can provide.


--
--------------------------------- --- -- -
Posted with NewsLeecher v3.95 Beta 1
Web @ http://www.newsleecher.com/?usenet
------------------- ----- ---- -- -

Count occurance of a leter in a text string <-- Thanks loads
 

Let's assume A1 contains the text of the current sign and B1 contains the
text of the new sign.

Enter a couple of column headers in say I1 and J1:

I1 = Current
J1 = New

Enter the letters A, B, C, D, .... Z in cells H2:H27

Enter this formula in I2:

=LEN(A$1)-LEN(SUBSTITUTE(UPPER(A$1),$H2,""))

Copy across to J2

If the result in column J is greater than the result in column I you need
the difference. You can put another formula in column K to get the
difference but you can probably figure out how to do that.


--
Biff
Microsoft Excel MVP


"justaman" wrote in message
...
Needing to make a simple billboard sign making sheet.

The operator would enter the sign's current text and in another
cell enter the new text.

The sheet would show the number of each letter used in the current
sign and compare to that needed in the new sign and show those
letters need to complete the new sign.

That way the workers would only have to carry the necessary letters
up the ladder to complete the new billboard.

Thanks for any help you can provide.


--
--------------------------------- --- -- -
Posted with NewsLeecher v3.95 Beta 1
Web @ http://www.newsleecher.com/?usenet
------------------- ----- ---- -- -






--
--------------------------------- --- -- -
Posted with NewsLeecher v3.95 Beta 1
Web @ http://www.newsleecher.com/?usenet
------------------- ----- ---- -- -