| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookyp fails due to space at the end
Dear Expert,
I need to vlookup following items and match the fields ... Basically, this task is easy and straightforward. However, system generated file will give unnecessary space at the end. That is "Exotic Package OTC ". Number oif space is irregular for each cell. That's it ... System adds a lot of space after the text and finally makes vlookup fails. How can I remove the unnecessary space after the last alphabet of each cell please? Text to column ... try before but cant. Replace " " (Space) with blank .... try before but cant ... because it becomes ExoticPackageOTC (one word), then vlookup cannot make it again. What function can screen out the unnecessary space after the last alphabets please? Thanks ... |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Vlookyp fails due to space at the end
How about trying TRIM to clean it up?
-- Max Singapore http://savefile.com/projects/236895 Downloads:25,000 Files:300 Subscribers:70 xdemechanik --- "Elton Law" wrote: I need to vlookup following items and match the fields ... Basically, this task is easy and straightforward. However, system generated file will give unnecessary space at the end. That is "Exotic Package OTC ". Number oif space is irregular for each cell. That's it ... System adds a lot of space after the text and finally makes vlookup fails. How can I remove the unnecessary space after the last alphabet of each cell please? Text to column ... try before but cant. Replace " " (Space) with blank .... try before but cant ... because it becomes ExoticPackageOTC (one word), then vlookup cannot make it again. What function can screen out the unnecessary space after the last alphabets please? Thanks ... |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Vlookyp fails due to space at the end
trim will definitly do te trick
"Elton Law" wrote: Dear Expert, I need to vlookup following items and match the fields ... Basically, this task is easy and straightforward. However, system generated file will give unnecessary space at the end. That is "Exotic Package OTC ". Number oif space is irregular for each cell. That's it ... System adds a lot of space after the text and finally makes vlookup fails. How can I remove the unnecessary space after the last alphabet of each cell please? Text to column ... try before but cant. Replace " " (Space) with blank .... try before but cant ... because it becomes ExoticPackageOTC (one word), then vlookup cannot make it again. What function can screen out the unnecessary space after the last alphabets please? Thanks ... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Space removal - a first name,space last name | Excel Discussion (Misc queries) | |||
| Printing fails on A3 | Excel Discussion (Misc queries) | |||
| Can I automatically add space after ea. row ("Space After" in Word | Excel Discussion (Misc queries) | |||
| formula that will go up one space if no value in specified space | Excel Worksheet Functions | |||
| Paper Space / Model Space ? | Excel Discussion (Misc queries) | |||
![Elton Law[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
