RE: inexact search
From: Frank Kabel (frank.kabel_at_freenet.de)
Date: 10/25/04
- Next message: s_u_resh: "Auto Sum formula - how to write in Macro"
- Previous message: alfonso gonzales: "I need the original digit format with zeroes untrimmed"
- In reply to: Mourinho: "inexact search"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 25 Oct 2004 08:29:03 -0700
Hi
have a look at the TRIM function to manipulate these entries
"Mourinho" wrote:
>
> I have a sheets containing data with headers that I am going to manipulate
> with a macro. The problem is that the headers contain spaces after the text
> (though not always) and so a search when referenced to another cell (e.g.
> using VLOOKUP or IF statement- not decided yet) is coming back empty.
>
> One option is to edit the input data first using a simple macro
> (Find+Replace), though I would be keen to learn of options if available.
>
> Cheers
>
> M
- Next message: s_u_resh: "Auto Sum formula - how to write in Macro"
- Previous message: alfonso gonzales: "I need the original digit format with zeroes untrimmed"
- In reply to: Mourinho: "inexact search"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
