Thread: How do I remove carriage returns from a cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BELINDA BELINDA is offline
external usenet poster
  
Posts: 6
Default How do I remove carriage returns from a cell
I have a program that when the information is put into an excel 2003 format
it appears as below all in 1 cell. I need to be able to have it all on 1
line to be able to do a text to columns to get just the information I need.

"FED WIRE OUT ORIGINATOR:
INC AC/ BENEFICIARY:
RECVBNK: ABA: RFB:200807
OBI: TRANSFER
ACCOUNT TRN:
FED REF/TIME: DATE:08-01-08 POST TIME:09:26:03"

Reply With QuoteReply With Quote