I warmly welcome. I would like to know how to add additional text to the data in Excel in each cell in a given column to the existing one. And how to automatically break sentences into words separated by commas. I mean something like that, initially I have the first column. How do I get the rest...

Connecting texts: = CONCATENATE (Cheapest:, A1, B1) Searching for spaces in the text: = SEARCH (, A1,1)

As for commas, he suggests = SUBSTITUTE (A1, ; ,)

[Excel] - How to Append Text to Each Cell and Split Sentences into Comma-Separated Words

Reply | New topic

#1 9705948 11 Jul 2011 16:44

zyga435 zyga435

Level 10

» |

Post #1
9705948 11 Jul 2011 16:44

I warmly welcome.

I would like to know how to add additional text to the data in Excel in each cell in a given column to the existing one. And how to automatically break sentences into words separated by commas.

I mean something like that, initially I have the first column. How do I get the rest? I know it is executable but I don't know how to do it.
ADVERTISEMENT
#2 9706081 11 Jul 2011 17:29

PeteSh PeteSh

Level 30

» | Positive voted Helpful post? (+7)

Post #2
9706081 11 Jul 2011 17:29

Connecting texts:
= CONCATENATE ("Cheapest:", A1, B1)
Searching for spaces in the text:
= SEARCH ("", A1,1)
ADVERTISEMENT
#3 9709124 12 Jul 2011 13:53

marek003 marek003

Level 40

» | Helpful post? (+1)

Post #3
9709124 12 Jul 2011 13:53

As for commas, he suggests
= SUBSTITUTE (A1, ""; ",")
#4 9724830 16 Jul 2011 13:59

zyga435 zyga435

Level 10

» | Topic author Helpful post? (0)

Post #4
9724830 16 Jul 2011 13:59

everything ok
Create an account, log in and become active in a forum and ads will not appear. You will receive points by participating in discussions.
Join this discussion.

Install the application

Didn't find an answer? Ask Artificial Intelligence

*I agree to send the question to OpenAI, Anthropic PBC, Perplexity AI, Inc., Kagi Inc., Google LLC - owners of language models in order to prepare the best response. The companies may monitor and log information entered into the form.

*I agree to publicly display my question and answer. The question and answer will be publicly available to everyone. The process may take a few minutes. Upon completion, you will be redirected to the page with the answer.

Wait...(2min)

Reply | New topic

Report a violation of the law

[Excel] - How to Append Text to Each Cell and Split Sentences into Comma-Separated Words

Didn't find an answer? Ask Artificial Intelligence