Line Break on a specific character

  • Thread starter Thread starter Ekser
  • Start date Start date
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
 
I think we will need more information.
Where is the data with the comma
 
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))
 
You must log in or register to reply here.

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

Automatic line break in cells 4
Force line break based on text 3
How do I get a line break to always work? 2
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
line break does not appear in CSV 3
Line Breaks in cells - Mac OS X Leopard 1
Line break in custom date format? 6
How do I search and replace with a line break? 12

Back
Top