| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VBA to concatenate Text and/or Numbers and/or dates etc
2003
What function(s) in VBA could I use to treat the contents of any cell as text, so that, I could concatenate all of the information. C1 = Chicago D1 = is E1 = 252 F1 = miles G1 = 7/24/2006 Therefo A1 = C1&D1&E1&F1&G1 (Of course this formula does not work because the data is inconsistent) Complicating matters is that columns C thru G can have any type of data. Is this a hopless case? Thanks EagleOne |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
| Text Wrapping | Excel Discussion (Misc queries) | |||
| how do I concatenate text that has a quotation mark | Excel Discussion (Misc queries) | |||
| space between text strings with concatenate | Excel Discussion (Misc queries) | |||
| Autofitting a row | Excel Discussion (Misc queries) | |||
Threaded Mode
