bullet

  1. E

    How to insert special characters with formula?

    Hello! Can you tell me please how to insert to cells the below characters/format, preferably with a formula as I want to blend them with other text and formulas. • Dfgdfg o Fdgdfgdfg  Fgdfgdfg if the above don't display correctly, you can get them from MSWord where it is basically the first...
  2. I

    Select bullet option on userform

    Hi, As per title. If you tab through the different bullet options on a userform how do you select one of them by pressing the enter button. Thanks
  3. T

    Need to convert multiple Excel cells into a combined htlm bullet point format

    Hi all, I use Excel frequently, but would only dare say I'm proficient with the basic processes. I need to import several thousand lines of inventory data to an online inventory program via a csv file. The new program I'm using only allows me to import one data field for ALL the bullet points...
  4. RobbieC

    vba - replace # key with bullet point

    Hi there, I have a spreadsheet which I need to replace a users keystroke with a bullet point when they type. I thought that the # key would be suitable as it doesn't have much use in this document... I was hoping to use some code such as: Application.OnKey "#", "addBulletPoint" so that when...
  5. R

    *Tricky* - trying to concatenate which will permit bullets when copied out

    Hi - this seems to be a bit tricky. I've got a sheet with columns - each column, say 3 of them, is a list of items (actually they're summary points from colleagues). I concatenate just using & but clean the text and skip the blanks. I add a CHAR(10) at the end of each point that I concatenate...
  6. P

    Splitting out text in cell A1

    Hi I have a series of sentences with bullet points all in cell A1 of a workbook. I would like to split out so each bullet point has its own cell in column A. The second bullet point would go into cell A2 and so on. Is this possible? Appreciate any help.
  7. T

    Inserting color in VBA email code

    Hey! I am trying to have certain lines of my ebody be red & bold and also create a bullet list. I currently have just a bullet entered, but no list. And the color, I'm totally lost on. Below is the code. Line 1 of the ebody needs to be red, and the line with Chr (149) is where I have the bullet...
  8. D

    Convert Excel Cell to Bullet Points HTML (<li></li>)

    Hello, So I've gotten like 6 spreadsheets with Data, and one of them is product features, they've been sent to me with either the bullet point (just the dots) or hyphens. Each spreadsheet contains 70 products, so about 420. I've used Replace and Find to remove them so it's just a simple list...
  9. J

    Counting number of rows if at least one instance appears in one of three columns

    Hi, all, Hoping someone can help me solve this. I have a spreadsheet with four columns (columns are sessions). The rows are weeks. So, I'm using a bullet point to indicate when I've attended any one of up to four sessions in each week. A B C D 1 • x x x 2 x • •...
  10. E

    Formatting amount of bullet points based on value given in list

    I've searched around and cant seem to find a definitive answer... I have created a data validation list going from 1 - 20, what I am trying to do is: based on the value given on that list have the corresponding amount of bullet points in the next column. So, if a user highlights 5 within the...
  11. N

    If statement within a bullet chart

    Hello, Hoping someone will be able to help as I've hit a brick wall!! I have created bullet charts to show finance and performance all on one chart for all the organisations we work with. The performance side of things works well but the finance only works if the organisation has either spent...

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