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)&"-")