character count

  1. D

    Count length of text characters in a cell that has a formula

    I've searched everywhere! The COUNTIF/COUNTA isn't what I need. The spreadsheet is like this: example Column D Col N Col O Name/Description External calling name Char Count Bobby...
  2. J

    Question about Function =LEN(cell) - Cell Character Count

    Hi Folks! I have a spreadsheet that I'm working on for a client and each cell cannot exceed 26 characters. In performing a Google search, I came across the function =LEN(cell). My questions is this, would it be possible to compose this function in a way that it would process an entire column...
  3. S

    enter specific number of characters based off a number in a different cell.

    I am using wingdings font, the Flag symbol (Shft+o), I want to be able to show a certain amount of Flags in a cell based of the number in another cell. Example: Cell A1 shows the number "80" Cell B1 should have 80 Flags/characters. Any ideas??
  4. A

    Character Count Limit

    Hi everyone, first post... Need help. I need to set a specific character count in an excel cell. I only have 5 lines, first line is a count of 50 characters (including spaces) and the rest are a count of 75. If it can't be done, Word is an option. Really need to get this done asap, any help is...
  5. J

    Capturing a set quantity based on delimiter

    Good morning, I have a concatenation of unique identifiers, separated by commas, in column A. I have a formula in Column B which is as follows: =LEFT(A1,FIND(CHAR(1),SUBSTITUTE(A1&",",",",CHAR(1),2))-1) which identifies the first two unique identifiers in A: A: 01,02,03,04,05 B...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top