LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 161
Default Remove newline char from string

My strings might have multiple newline characters at the
beginning of the string AND/OR at the end of the string.
What is a good way to remove those newline or
carriage return characters?

BTW, I am only concerned about extra newlines at the beginning
or end of the string. It is okay to have newline characters
in the middle of the string.

~Robert



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
table column name with newline, cannot select with string [email protected] Excel Programming 1 February 19th 14 07:12 PM
Remove the char from right Ranjith Kurian[_2_] Excel Worksheet Functions 2 October 13th 09 01:41 PM
How to substitute a comma with a newline char using Replace. edspyhill01 Excel Discussion (Misc queries) 9 July 30th 06 12:38 AM
last char of a string Buddy Lee Excel Programming 9 November 11th 05 02:02 AM
How do I remove Char(160) from a cell? Dave Excel Worksheet Functions 2 February 3rd 05 02:06 PM


All times are GMT +1. The time now is 04:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"