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 & separate each word word with a space?
thanks

"CLR" wrote:

If you have text in a cell with the words separated by spaces, you can use
the Data TextToColumns feature with "space" as a delimiter to split each
word out into it's own column..........then you can use the CONCATENATE
function to put them back together in any order you wish..........

hth
Vaya con Dios,
Chuck, CABGx3



"nastech" wrote:

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.

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

=A1&" "&A6&" "&A4&" "&A2&" "&A3&" "&A5 ..... etc etc etc

hth
Vaya con Dios,
Chuck, CABGx3



"nastech" wrote:

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

"CLR" wrote:

If you have text in a cell with the words separated by spaces, you can use
the Data TextToColumns feature with "space" as a delimiter to split each
word out into it's own column..........then you can use the CONCATENATE
function to put them back together in any order you wish..........

hth
Vaya con Dios,
Chuck, CABGx3



"nastech" wrote:

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, 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 & 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: "."
periods.
have: =V398&" "&V399&" " but have many records / unwanted space lines.
(possible answer to excluding "." 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, & can skip
unwanted line space characters (e.g.: where cell only contains a "." period).

maybe something like:
=IF(OR(A1=".",A1=".blank."),then skip,A1:A3000)&" ")


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("a" & Rows.Count).End(xlUp).Row
For Each c In Sheets(1).Range(Cells(5, 1), Cells(x, 1))
symbols = symbols & "+" & c


"CLR" wrote:

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

=A1&" "&A6&" "&A4&" "&A2&" "&A3&" "&A5 ..... etc etc etc

hth
Vaya con Dios,
Chuck, CABGx3



"nastech" wrote:

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

"CLR" wrote:

If you have text in a cell with the words separated by spaces, you can use
the Data TextToColumns feature with "space" as a delimiter to split each
word out into it's own column..........then you can use the CONCATENATE
function to put them back together in any order you wish..........

hth
Vaya con Dios,
Chuck, CABGx3



"nastech" wrote:

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.