Substring

[Sudhakar]

How to substring a string to specified length?

dim temp as string

temp = "Qre60200000"

I want to display in a message box like this

6020 0000.(There should be a space inbetween).How to do that/

Thanks.

[jim mcnamara]

tmp = "ABCxxxxxxxx"
temp = mid(temp,4)
temp = left(temp,4) & " " & mid(temp,5)

temp is now "xxxx xxxx"

[Static]

tmp = "ABCxxxxxxxx"
temp = mid(temp,4)
temp = left(temp,4) & " " & mid(temp,5)

jim temp = "" check your spelling mister!
j/k


temp = "ABCxxxxxxxx"
temp = mid(temp,4,4) & " " & right(temp,4)

one less step