Text to Data Separation

[segran]

Hi,

How can I separate data with the following separator: the one in symbols that just looks like a vertical line.



Please help. Thank you

 

[Joe4]

Select the column, use "Text to Columns" under the Data menu, and choose the Delimited option, choosing that "pipe symbol" ("|") as your delimiter.

 

[segran]

How do I get the pipe delimiter - i dont see it there.

 

[Joe4]

On my keyboard, it is just above the ENTER key (using SHIFT).

 

[Andrew Poulsom]

On mine (UK) it's to the left of Z (using Shift).

 

[segran]

Thank you