software

Hi, is there a formula or script for copying a portion of a column / selected
range of words/text, to a single cell. Looking for separation by spaces, and
option to have sorted as listed, or alphabetically. Thanks.

Hi, is that the same for column of single words, want to send portion
(hilighted work?) to a single cell amp; separate each word word with a space?
thanks

quot;CLRquot; wrote:

gt; If you have text in a cell with the words separated by spaces, you can use
gt; the Data gt; TextToColumns feature with quot;spacequot; as a delimiter to split each
gt; word out into it's own column..........then you can use the CONCATENATE
gt; function to put them back together in any order you wish..........
gt;
gt; hth
gt; Vaya con Dios,
gt; Chuck, CABGx3
gt;
gt;
gt;
gt; quot;nastechquot; wrote:
gt;
gt; gt; Hi, is there a formula or script for copying a portion of a column / selected
gt; gt; range of words/text, to a single cell. Looking for separation by spaces, and
gt; gt; option to have sorted as listed, or alphabetically. Thanks.

Perhaps I misunderstood what you are looking for............If you have
words, each in their own cells down column A, you can CONCATENATE them
together with spaces in between them in any order you choose.......in B1 put
this formula

=A1amp;quot; quot;amp;A6amp;quot; quot;amp;A4amp;quot; quot;amp;A2amp;quot; quot;amp;A3amp;quot; quot;amp;A5 ..... etc etc etc

hth
Vaya con Dios,
Chuck, CABGx3
quot;nastechquot; wrote:

gt; Hi, is that the same for column of single words, want to send portion
gt; (hilighted work?) to a single cell amp; separate each word word with a space?
gt; thanks
gt;
gt; quot;CLRquot; wrote:
gt;
gt; gt; If you have text in a cell with the words separated by spaces, you can use
gt; gt; the Data gt; TextToColumns feature with quot;spacequot; as a delimiter to split each
gt; gt; word out into it's own column..........then you can use the CONCATENATE
gt; gt; function to put them back together in any order you wish..........
gt; gt;
gt; gt; hth
gt; gt; Vaya con Dios,
gt; gt; Chuck, CABGx3
gt; gt;
gt; gt;
gt; gt;
gt; gt; quot;nastechquot; wrote:
gt; gt;
gt; gt; gt; Hi, is there a formula or script for copying a portion of a column / selected
gt; gt; gt; range of words/text, to a single cell. Looking for separation by spaces, and
gt; gt; gt; option to have sorted as listed, or alphabetically. Thanks.

Hi, Thankyou!! gives me a start, would have gotten that eventually, did
similar with hyperlinks, anding pieces together. So with your example, I
think I can copy amp; paste-special to another cell to get the results. Thanks
for the help...

Goal: Column of single word cells, put together in a single cell, separated
by spaces. Looking to select a range, and exclude lines with e.g: quot;.quot;
periods.
have: =V398amp;quot; quot;amp;V399amp;quot; quot; but have many records / unwanted space lines.
(possible answer to excluding quot;.quot; periods might then be using FIND-REPLACE
afterwards.

Is there something a little more proactive, if have 3k lines, selecting only
a portion maybe, but typing cell numbers unique to each line would 1/2 defeat
just typing words to start with. Maybe something with a range, amp; can skip
unwanted line space characters (e.g.: where cell only contains a quot;.quot; period).

maybe something like:
=IF(OR(A1=quot;.quot;,A1=quot;.blank.quot;),then skip,A1:A3000)amp;quot; quot;)p.s. got some script from someone, with no directions, have no idea how to
make work: (can copy paste to code tab, but after that). not sure if wrong
answer, so have to pay, but not in a money position just yet.

x = Sheets(1).Range(quot;aquot; amp; Rows.Count).End(xlUp).Row
For Each c In Sheets(1).Range(Cells(5, 1), Cells(x, 1))
symbols = symbols amp; quot; quot; amp; cquot;CLRquot; wrote:

gt; Perhaps I misunderstood what you are looking for............If you have
gt; words, each in their own cells down column A, you can CONCATENATE them
gt; together with spaces in between them in any order you choose.......in B1 put
gt; this formula
gt;
gt; =A1amp;quot; quot;amp;A6amp;quot; quot;amp;A4amp;quot; quot;amp;A2amp;quot; quot;amp;A3amp;quot; quot;amp;A5 ..... etc etc etc
gt;
gt; hth
gt; Vaya con Dios,
gt; Chuck, CABGx3
gt;
gt;
gt;
gt; quot;nastechquot; wrote:
gt;
gt; gt; Hi, is that the same for column of single words, want to send portion
gt; gt; (hilighted work?) to a single cell amp; separate each word word with a space?
gt; gt; thanks
gt; gt;
gt; gt; quot;CLRquot; wrote:
gt; gt;
gt; gt; gt; If you have text in a cell with the words separated by spaces, you can use
gt; gt; gt; the Data gt; TextToColumns feature with quot;spacequot; as a delimiter to split each
gt; gt; gt; word out into it's own column..........then you can use the CONCATENATE
gt; gt; gt; function to put them back together in any order you wish..........
gt; gt; gt;
gt; gt; gt; hth
gt; gt; gt; Vaya con Dios,
gt; gt; gt; Chuck, CABGx3
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;nastechquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; Hi, is there a formula or script for copying a portion of a column / selected
gt; gt; gt; gt; range of words/text, to a single cell. Looking for separation by spaces, and
gt; gt; gt; gt; option to have sorted as listed, or alphabetically. Thanks.