| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
inexact search
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
inexact search
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Functions (search within search result) reply to this please | Excel Worksheet Functions | |||
| Comparing similar but inexact text | Excel Worksheet Functions | |||
| How do I count words in a column if they are inexact? | Excel Worksheet Functions | |||
| How do I search excel spreadsheets using multiple search criteria. | Excel Worksheet Functions | |||
| Inexact? InsideTop and InsideLeft Method of PlotArea (Excel 97) | Charts and Charting in Excel | |||
Linear Mode
