| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Removing character in a string
When importing an excel file the character " ' " appears in front of a zip
code; '85004 this hinders the vlookup formula. How can I remove this character en mass? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Removing character in a string
Select the column of cells
CTRL+H Replace: ' With: Click REPLACE ALL button "MikeL" wrote: When importing an excel file the character " ' " appears in front of a zip code; '85004 this hinders the vlookup formula. How can I remove this character en mass? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Removing character in a string
Maybe you could modify your =vlookup()
If the value you're matching on has to be text and is currently a number: =vlookup(""&x99,sheet2!a:b,2,false) or =vlookup(text(x99,"00000"),sheet2!a:b,2,false) ""&x99 will convert the number value in x99 to text. =text(x99,"0000") will keep the leading 0's MikeL wrote: When importing an excel file the character " ' " appears in front of a zip code; '85004 this hinders the vlookup formula. How can I remove this character en mass? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Removing a character | Excel Worksheet Functions | |||
| Excel-Match 1st text character in a string to a known character? | Excel Worksheet Functions | |||
| Removing last character in a cell | Excel Worksheet Functions | |||
| Removing last character in a cell | Excel Worksheet Functions | |||
| NEED HELP-----Removing a space at the end of a string of character | Excel Discussion (Misc queries) | |||
Hybrid Mode
