Home > OS >  Editing text in Excel: Paste a '-' before each word in a cell
Editing text in Excel: Paste a '-' before each word in a cell

Time:11-14

I have a large excel file containing multiple words per cell. Like this:

       A1
1    Word 1
     Word2
     Word e 3

2    Word 1
     Word2
     Words3

I want to place a '-' before each word in the cell, so the result must be:

     A1
1    -Word 1
     -Word2
     -Word e 3

2    -Word 1
     -Word2
     -Words3

I do not want to split the words in to separate cells in order for it to work. Been fiddling with it for a while, but i cant find a function/solution that does the job without splitting the words into separate cells.

Thanks in advance.

CodePudding user response:

Use SUBSTITUTE:

="-"&SUBSTITUTE(A1,CHAR(10),CHAR(10)&"-")

enter image description here

  • Related