| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell reference
"Pete Elbert" wrote:
.. However in C1 I have a formula =A1&","&A2&","&A3&","&A4&"" For an automated neater display, put instead in C1: =SUBSTITUTE(TRIM(A1&" "&A2&" "&A3&" "&A4)," ",",") -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nesting a sheet name reference within a cell reference??? | Excel Discussion (Misc queries) | |||
| Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
| How do I anchor a cell reference? | Excel Discussion (Misc queries) | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| Cell Reference Math | Excel Worksheet Functions | |||
Hybrid Mode
