Convert multiple cells into one string, with spaces between values

A

amthyst826

I have a column of data. I need to concatenate it into one long
string, with spaces between each value.

The final; result is a search string, but the number of values is going
to vary depending on the number of fails found.

Meaning... Column A could be 10 rows, 20 rows, 75 rows, it varies
depending on a specific starting point.

=concatenate(A1," ",A2" ",A3)
Will return the desired result, Can I avoid having to type all of the
cells, from A1 to A200.

Thanks!!

Previous solution? Copy column, paste into Word, Convert Table to
Text, Replace Paragraph mark with space. Viola, search string created.
Now, to publish my trick to a range of users, I need to keep it in
Excel and not use Word.

Michelle
 
K

Klatuu

This news group is for Access. Perhaps you should post your question in an
Excel group.
 
L

Larry Linson

This looks very much like a question about Excel, but this newsgroup is
about the Forms in Microsoft Access database software. If your question is
about Access, please clarify. If not, there are a number of newsgroups about
Excel where the question would stand a better chance of getting a useful
answer.

Larry Linson
Microsoft Access MVP
 
J

John Vinson

I have a column of data. I need to concatenate it into one long
string, with spaces between each value.

The final; result is a search string, but the number of values is going
to vary depending on the number of fails found.

Meaning... Column A could be 10 rows, 20 rows, 75 rows, it varies
depending on a specific starting point.

=concatenate(A1," ",A2" ",A3)
Will return the desired result, Can I avoid having to type all of the
cells, from A1 to A200.
Click to expand...

You've posted an Excel question in a Microsoft Access newsgroup.
Please repost in an Excel newsgroup - you'll get a better chance of
getting a correct answer!

John W. Vinson[MVP]
 
Top