Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
erasing space/blank in a cell
Hi
i'm doing alot of vlookup work and very common to facea problem in linking becaouse of additional space or blank line does anyone have an idea how can it be overcomed? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
erasing space/blank in a cell
Hi,
try this, highlight the column where you have the information, ctrl H, that will take it to the replace screen, let's say you have 1 blank space, in find what press the space bar one , then tab to replace with, don't do anything here and press replace all. hope this help "thread" wrote: Hi i'm doing alot of vlookup work and very common to facea problem in linking becaouse of additional space or blank line does anyone have an idea how can it be overcomed? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
erasing space/blank in a cell
On 15 Jan., 15:17, thread wrote:
Hi i'm doing alot of vlookup work and very common to facea problem in linking becaouse of additional space or blank line does anyone have an idea how can it be overcomed? Hi, there is a function called trim. This enables you to take out all the spaces at the beginning of the cell. Maybe that one helps |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
erasing space/blank in a cell
Sub TRIM_EXTRA_SPACES()
Dim Cell As Range For Each Cell In Selection If (Not IsEmpty(Cell)) And _ Not Application.IsNumber(Cell.Value) And _ InStr(Cell.Formula, "=") = 0 _ Then Cell.Value = Application.Trim(Cell.Value) Next End Sub Gord Dibben MS Excel MVP On Thu, 15 Jan 2009 06:17:08 -0800 (PST), thread wrote: Hi i'm doing alot of vlookup work and very common to facea problem in linking becaouse of additional space or blank line does anyone have an idea how can it be overcomed? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Delete content of cell without erasing existing formula? | Excel Discussion (Misc queries) | |||
add blank space in cell if first name is not blank | Excel Worksheet Functions | |||
Code Erasing Cell Contents Inappropriately | Excel Programming | |||
I want a blank space on a worksheet when the question is blank? | Excel Discussion (Misc queries) | |||
How do I clear blank space at the top of a word-wrapped text cell? | Excel Discussion (Misc queries) |