How do I parse for fields separated by a carriage control within a cell?

V

veritasca

Inside a cell, there are many filenames separated by a carriage return.
I have to extract each filename and write it out to a text file. If I
use InStr function to find the carriage return value, what is the value
that I should use? I know Alt+Enter is used to cause the carriage
return (cause the cell's content to wrap within the cell). So:
Pos = Instr(CellText, Alt+Enter), is that OK?

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum http://www.ozgrid.com/forum ***
 
G

Gord Dibben

Chr(10) or Chr(13)

Manually, Data>Text to Columns and ALT + 0010 in the Delimited by "Other" box
will work to split the data to separate cells.

Gord Dibben Excel MVP
 

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

Use a Carriage Returns when typing data into a text cell 1
Use a Carriage Return when typing data into a text cell 2
Separating carriage return data into separate cells 2
Remove carriage returns in memo fields 1
Parsing line breaks into separate cells 3
how do I insert carriage return into mergefield 2
Excel: How to insert carriage returns in a formula to manipulate t 1
Alt+enter to carriage return within a cell does not work...? 2

Top