| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
space
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? |
|
#2
|
|||
|
|||
|
Select the import, do editreplace, 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 "frank" wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| space between y axis and data points.. | Charts and Charting in Excel | |||
| Trailing Space / Format Question | Excel Discussion (Misc queries) | |||
| HELP - I need to change space delimited to comma? | Excel Discussion (Misc queries) | |||
| Non-Breaking Space + Print Issue | Charts and Charting in Excel | |||
| create space in line chart between points, linked to pivot table | Charts and Charting in Excel | |||
Hybrid Mode
