'extracting cell value with multiple lines
If (InStr(clientname, Chr(10)) > 0) Then
tempArray = Split(clientname, Chr(10))
clientname = tempArray(0)
End If
If (InStr(clientname, Chr(10)) > 0) Then
tempArray = Split(clientname, Chr(10))
clientname = tempArray(0)
End If