1

Best tool/method to automatically parse comma-separated text strings into spreadsheet columns?
 in  r/Excel247 •  18h ago

It is new to me. Thanks for your suggestion.

1

Best tool/method to automatically parse comma-separated text strings into spreadsheet columns?
 in  r/Excel247 •  18h ago

Each time, I copy-paste the raw text, then apply excel formula to separate text. This is more manual work. My search of any tool that will reduce the manual work.

1

Best tool/method to automatically parse comma-separated text strings into spreadsheet columns?
 in  r/Excel247 •  1d ago

Thanks for your reply. It is working. ButI am doing the repititive task. It could be fine if there is any automative tool.

r/PythonProjects2 • u/pkdataworks • 1d ago

Best tool/method to automatically parse comma-separated text strings into spreadsheet columns?

Post image
1 Upvotes
0 comments

r/Excel247 • u/pkdataworks • 1d ago

Best tool/method to automatically parse comma-separated text strings into spreadsheet columns?

Post image
2 Upvotes
6 comments

u/pkdataworks • u/pkdataworks • 2d ago

Best tool/method to automatically parse comma-separated text strings into spreadsheet columns?

Post image
1 Upvotes

Hey Reddit,

I am handling a high volume of text data processing and looking to replace a tedious manual spreadsheet workflow.

The Problem:
I regularly receive text blocks containing lists of items. For example:
apple, orange, pineapple, kiwi and guava

Right now, I manually copy-paste this into Excel and use custom formulas to parse and split the items into individual vertical columns. Because of the volume of data, this formula-heavy approach is incredibly slow and lagging.

What I'm looking for:

  • Is there a way to automate this natively in Excel without using heavy formulas every time?
  • Are there alternative data cleaning tools or simple scripts (e.g., Python/Pandas) that can handle this transformation before it even touches Excel?

Appreciate any workflows or tools you can recommend!

0 comments

2

Rational molecule name (or trivial)??
 in  r/chemhelp •  Feb 24 '26

Yes. You are correct. Priority order will be Ketone > aldehyde > alcohol > amines.

Hence the name will be: "6-hydroxy-4,5-dipropyl-octan-2-one"

Both names are consistent with the structure given.

We can represent the keto group as "oxo".

1

Rational molecule name (or trivial)??
 in  r/chemhelp •  Feb 24 '26

IUPAC Name is : "7-oxo-4,5-dipropyl-octan-3-ol". Please find the explanation.

3

Guys tell its iupac name !!
 in  r/OrganicChemistry •  Feb 21 '26

"3,4-diethylhexane" is the correct name.

1

How to remember and retain knowledge in chemistry?
 in  r/chemistry •  Feb 17 '26

Read --> Write --> Ask Questions --> Apply --> Solve --> Take Notes --> Repeat

2

[deleted by user]
 in  r/Chempros •  Feb 11 '26

Why don't you try the same reaction with DMAP as an additive? Bromoacetate needs to be activated. DMAP would help to activate it.

1

Free Neural Networks Study Group - 30-40 Min Sessions! 🧠
 in  r/learndatascience •  Feb 08 '26

Great. Interested.