| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return text between look up function.
I have a formula shown below, where I want to return a populated field from a
csv file but between the 2 look up returns I would like to display "X". General Im trying to display a width X length in another work sheet. =(dyCAR.csv!$D$9) X (dyCAR.csv!$D$11) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Return text between look up function.
Hi,
=(dyCAR.csv!$D$9)&"X"&(dyCAR.csv!$D$11) "Rspiva" wrote: I have a formula shown below, where I want to return a populated field from a csv file but between the 2 look up returns I would like to display "X". General Im trying to display a width X length in another work sheet. =(dyCAR.csv!$D$9) X (dyCAR.csv!$D$11) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Return text between look up function.
Do you mean
=dyCAR.csv!$D$9 & "X" & dyCAR.csv!$D$11 If this post helps click Yes --------------- Jacob Skaria "Rspiva" wrote: I have a formula shown below, where I want to return a populated field from a csv file but between the 2 look up returns I would like to display "X". General Im trying to display a width X length in another work sheet. =(dyCAR.csv!$D$9) X (dyCAR.csv!$D$11) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return Certain Text with IF function | Excel Worksheet Functions | |||
| How to convert function return value to text? | Excel Worksheet Functions | |||
| Need function to return text value | Excel Worksheet Functions | |||
| Need Function to look up value and return a text value? | Excel Worksheet Functions | |||
| What function do I use to return a certain value for specific text | Excel Discussion (Misc queries) | |||
Linear Mode
