Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a column where each cell contains a single letter. I need to
consolidate all these letters and form a single string of text in a separate cell. In other words, a function equivalent to sum() for characters is what i'm looking for. Concatenate() works only with 34 cells, and creating a "sum" of different Concatenate() doesn't seem to work fine. Any smart way to solve my problem? Thanks, Stefano |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to delete part of the content on multiple cells in excel? | Excel Discussion (Misc queries) | |||
seperating text in one cell to multiple cells | Excel Discussion (Misc queries) | |||
Alphabetically reorder a text string with multiple words | Excel Worksheet Functions | |||
stopping pasted text deliminate across multiple cells | Excel Discussion (Misc queries) | |||
Help adding text values | Excel Worksheet Functions |