LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.setup
Rusty
 
Posts: n/a
Default carriage return code

I imported a list of contacts from outlook. Many of the imported street
addresses have a carriage return followed by a PO box or suite number. I
want to search the street address field and move the text to the left of the
carraige return to another colum. Problem is, I don't know how to search for
the carriage return. Can you help me?

Thanks,
 
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
t-distribution puzzle in Excel [email protected] Excel Discussion (Misc queries) 8 November 11th 05 10:27 AM
Text to columns delimited by carriage return EMG03 Excel Worksheet Functions 2 October 31st 05 07:35 PM
Squares for carriage return Helena Excel Worksheet Functions 3 July 6th 05 09:21 PM
How do I add a carriage return into a cell in Excel? pm Excel Discussion (Misc queries) 3 February 15th 05 12:45 AM
Find/Replace carriage return & line feed characters in Excel. Mary Cullen Excel Worksheet Functions 1 January 4th 05 07:39 PM


All times are GMT +1. The time now is 12:41 PM.

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

About Us

"It's about Microsoft Excel"