Blank but not empty cell

Mar 10th, 2002, 05:52 AM

Hi,
I have imported data from an external file into excel. Some of the cells seems to be blank but obviously not empty!!
They have length (4) and they do not "behave" as empty cells.
How can I transform them to blanks?
Eli

Matanuska · Mar 10th, 2002, 11:27 AM

Try selecting Edit/Replace... from the main Excel menubar and type a single space in the Find What box, leave the Replace With box blank, and Replace All.

This trick also works wonders when imported data refuses to plot correctly (spaces can cause all sorts of problems).

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

Mar 10th, 2002, 05:52 AM	#1
Guest Posts: n/a	Hi, I have imported data from an external file into excel. Some of the cells seems to be blank but obviously not empty!! They have length (4) and they do not "behave" as empty cells. How can I transform them to blanks? Eli

Mar 10th, 2002, 11:27 AM	#2
Matanuska New Member Join Date: Feb 2002 Location: Houston, Texas Posts: 28	Try selecting Edit/Replace... from the main Excel menubar and type a single space in the Find What box, leave the Replace With box blank, and Replace All. This trick also works wonders when imported data refuses to plot correctly (spaces can cause all sorts of problems).