Search code examples
excelexcel-formulaworksheet-functionsubstitutionbulletedlist

Replace bullets with numbering

I have the following text:

This is user message

  • Message one
  • Message two
  • Message three

where I want to replace all the bullets with numbers:

This is user message

  1. Message one
  2. Message two
  3. Message three

This text in available in only one cell of Excel file.

Can anyone suggest a formula to do so?

Solution

  • A different formula may suit for a different interpretation: 

     =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,"-","3.",3),"-","2.",2),"-","1.",1)

    SO26337578 example