Splitting data in a cell (2003)

Topic

New Reply

In the attached file, I need to split the data in the cell into mulitiple cells, making the break where the double-bar symbol is. I’ve tried a variety of ways to split the cell, but can’t seem to find the value I need to use to represent the double-bar symbol. For example, in the split function, is there something I can use for a delimiter to indicate the symbol?

The actual excel file I am working with has a whole column of fields with data that needs to be split.

Thanks for your help!

Reply | Quote

Replies

I don’t see a “double-bar” symbol. Which one is it?

Do you mean the Line feed character?
If so, select the cells
Data -text to columns
Delimited
Select Other
and hold -key and enter 0010 [from keypad] in the “other box”

It will put each separate item into a separate column
Steve

Reply | Quote

Thanks a lot! That was exactly what I needed!

Is there a place I could have looked up the value for that symbol? I looked quite a few places and couldn’t find it.

Reply | Quote

If you have it alone in a cell (or the first character) you can use the Code function to give its code value. The “LineFeed” character is code “10”. The line feed is what gets placed into a cell when you use to wrap in cells.

Steve

Reply | Quote