0

I am copying and pasting algo numbers into Google Sheets but doing quite a bit of work by hand. The numbers I copy looks like this: 16957.25 16679.75 16268.75 16072.5 15695.5 15447.5 15203.75 14801.25 14695.25 14490.5 13891.0 13076.25 12984.25. Of course these numbers are all pasted in the same cell. I then split each entry into its own cell in Column A. Is there a faster way?

2
  • from zapier.com › blog › split-text-excel-zapier How to Split Text in Excel, Google Sheets, and Your Other ... Select the text or column, then click the Data menu and select Split text to columns.... Google Sheets will open a small menu beside your text where you can select to split by comma, space, semicolon, period, or custom character. Select the delimiter your text uses, and Google Sheets will automatically split your text.
    – Daniele
    Commented Feb 10, 2022 at 15:57
  • Hi and welcome to WebApps. I am copying and pasting algo numbers into Google Sheets Would you please explain what you are copying the numbers "from". Are they in a file, would you provide a sample of the file content.
    – Tedinoz
    Commented Feb 11, 2022 at 0:45

1 Answer 1

1

you could even use a calculation, something like:

=SPLIT(A1," ")

This will split the text horizontally into cells. If you want to get it vertically instead, apply this formula:

=TRANSPOSE(SPLIT(A1," ")

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.