Convert multiple cells into one string, with spaces between values

  • Thread starter Thread starter amthyst826
  • Start date Start date
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
 
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
 
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]
 
Back
Top