| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple address lines in an 'if'
I want to insert an address into a merged cell depending on a location cell.
When I use the code below, Excel does not recognize the <alt enter. Any ideas? =IF(E2=1,"ABC Company<alt enter123 Street<alt enterAnytown, State Zip","DEF Company<alt enter456 Road<alt enterAnytown, State Zip") The <alt enter does not work in this text box, but I think you will understand what I want to do. Thanks for any help. Learner101b |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I place 3 lines of text (an address) in 1 cell? | New Users to Excel | |||
| display 1 line of multiple worksheets into multiple lines on 1 wks | Excel Worksheet Functions | |||
| Splitting comma separated lines of an address for mail merge. | Excel Discussion (Misc queries) | |||
| Display multiple lines of text within a cell from multiple column. | Excel Worksheet Functions | |||
| ?? Extra blank lines in 'address' cell after exporting to Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
