space

  • Thread starter Thread starter frank
  • Start date Start date
F

frank

i am downloading data from a program and pasting it to
EXCEL. there are times when in certain cells a small box
appears which I believe represents a space or who is ever
entering the data hitting ENTER. Is there a way to
remove this from all the cells?
 
Select the import, do edit>replace, put the cursor in the find what box, hold
down alt key while typing 010 on the numeric keypad, release alt key; Leave
replace with blank or put a space there, click replace all.


Regards,

Peo Sjoblom
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Space-bar -- "recurring" instead of <space> 1
Trailing Spaces in Merged Cells 1
Issue with blanks and spaces 56
Can I automatically have a space after the content in an Excel cel 2
Carriage return displays as a small box 8
Allow spaces between lines of text within cell 1

Back
Top