Line Break on a specific character

E

Ekser

Hi,

How can I insert a line break after a specific character (in this cas
after a comma ,)?
Let me stress that I don't have data in this cell for the moment, bu
it is used to be exported to Word, thus the cell value is unknown so
can't use the Data/Text to Columns option....


:confused:


Cheers
 
F

Frank Kabel

Hi
you could use the following in a helper column
=IF(ISNUMBER(FIND(",",A1)),LEFT(A1,FIND(",",A1)) & CHAR(10) &
MID(A1,FIND(",",A1)+1,1024),"")
and format this cell with word wrap ('Format -Cells - Alignment)

another option would be to try:
=SUBSTITUTE(A1,",",","&CHAR(10))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I get a line break to always work? 2
Automatic line break in cells 4
Line break in custom date format? 6
Force line break based on text 3
Count Instances of a Specific Character 2
Character for second line in a cell 2
How do I search and replace with a line break? 12
text to columns w a line break 6

Top