asked on

Need to remove extra white space from description field.

I have a description column which contains data like this :

"This unit uses the firemaster top, which prevents any accidental discharges.

The canister dimensions are 8 and seven-eight inches by 2 inches. An optional holster can be purchased.

Utilizes the Firemaster Safety Top to prevent accidental discharge
Contains 17% Oleoresin Capsicum which gives 2 million Scoville Heat Units
Has a 3 year shelf life
Can supply up to 150 one-second bursts
Total range of stream is 25-30 feet
Made in USA

Product : SW20"

The problem is I have to save this file as a "Tab Delimited" text file.

All the text in the description needs to be on "one line".

Is there anyway to remove all the extra white space in the description?
thanks

ASKER CERTIFIED SOLUTION

Leo Torres

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Leo Torres

if you have carriage return on a line this should be help full as well

http://www.justanswer.com/computer-programming/27rt7-replace-carriage-return-excel-needs.html

SOLUTION

kgerb

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

MikeMCSD

ASKER

thanks guys . . .

The Replace couldn't find those codes so I tried :

=SUBSTITUTE(C2, CHAR(13), " ") 'carriage returns

=SUBSTITUTE(C2, CHAR(10), " ") 'line feeds'

and they both worked the same.
Should I run both of them?

Leo Torres

yes run then both
they are replacing different things.. and you want to get the shortest string possible correct..

MikeMCSD

ASKER

worked . . thanks