Hi,
I am trying to find a solution for a problem..
I've got a string but I need to format it in a specific type....

#-0.6|141.443719976486|59.8780753410541|-0.6|140.736613195299|59.1709685598
#534359|59.1356132208082|-0.6|140.821466009042|59.1851106954913|
#17|-2.03|141.39422501803|59.828577866371|-2.03|140.78611066998259.2204660345
#9042|59.1851106954913|-2.03|140.821466009042|59.1851106954913|#40.82146600902.03140.786110669982|59.2204660345506|-2.03|140.786110669982|
#9042|59.1851106954913|-0.67|141.429577840862|59.7932225273117|-0.67|#140.821466009042|59.185110695491|

I am trying to end each line with "|" and move the rest of the characters to the next line....

Any help please!!

Hi, Use Split() function to split the strings
Syntax

Split(expression, delimiter)
Ex.

dim Obj as variant
Dim sSTring as String
sString = "#-0.6 ........"
Obj = Split (sString, "|")

.....