Copy List of text to a single cell?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy column of cells to a single cell? 7
Copy column range of "single word" cells with spaces to a single c 3
Incomplete text wrap within a single cell 1
copy formula result (text) only - without copying formula 2
Display text from a single cell in a column range 2
paste copied text to only one cell 4
How to type each letter of the alphabet automatically in a specific color in Word? 0
Formula to return a value for a portion of a text string in a cell 2

Back
Top