End line char

John Yazou · Mar 21st, 2002, 08:13 PM

Hi,
Wondering.. I have this statement in VBA, InStr(strTemp, ",") + 1.. what should I change in the "," part to find the end-of-line character??

Mark O'Brien · Mar 21st, 2002, 08:42 PM

I guess the end of line character is "carriage return". In which case, substitute "," with:



Chr(13)

Hope this is what you want.

[ This Message was edited by: Mark O'Brien on 2002-03-21 19:43 ]

[ This Message was edited by: Mark O'Brien on 2002-03-21 19:43 ]

Juan Pablo González · Mar 21st, 2002, 08:59 PM

If you're looking for the position of the last character, use Len(String)

Mar 21st, 2002, 08:42 PM	#2
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	I guess the end of line character is "carriage return". In which case, substitute "," with: Chr(13) Hope this is what you want. [ This Message was edited by: Mark O'Brien on 2002-03-21 19:43 ] [ This Message was edited by: Mark O'Brien on 2002-03-21 19:43 ]

Mar 21st, 2002, 08:59 PM	#3
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	If you're looking for the position of the last character, use Len(String) __________________ Regards, Juan Pablo González http://www.juanpg.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 21st, 2002, 08:13 PM	#1
John Yazou New Member Join Date: Mar 2002 Posts: 49	Hi, Wondering.. I have this statement in VBA, InStr(strTemp, ",") + 1.. what should I change in the "," part to find the end-of-line character??