Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP - 2 Questions
I have 2 questions in regards to VLOOKUP.
1 - Is it possible to retrain the format of the cell which you are pulling the value of? For example text color 2 - In some of the original cells, the Alt+Enter key was used to perform a cariage return within a cell. When VLOOKUP returns these cells, the cariage return shows as a block-type wingding. Is there a way to turn this back into a carriage return either through the function or using code? Thanks! Kathy |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP - 2 Questions
1. No
2. If you format the cell with the vlookup formula under formatcellsalignment and check wrap text it will be multiple lines whenever there is a carriage return, if you want to remove it or replace it with a space =SUBSTITUTE(VLOOKUP(A1,D3:E4,2,0),CHAR(10)," ") will replace the carriage return with a space -- Regards, Peo Sjoblom http://nwexcelsolutions.com "Kathy - Lovullo" wrote in message ... I have 2 questions in regards to VLOOKUP. 1 - Is it possible to retrain the format of the cell which you are pulling the value of? For example text color 2 - In some of the original cells, the Alt+Enter key was used to perform a cariage return within a cell. When VLOOKUP returns these cells, the cariage return shows as a block-type wingding. Is there a way to turn this back into a carriage return either through the function or using code? Thanks! Kathy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP Problem | Excel Discussion (Misc queries) | |||
VLOOKUP Questions | Excel Worksheet Functions | |||
vlookup and calculation questions | Excel Worksheet Functions | |||
VLOOKUP Limitations | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions |