Can anyone help me with an Excel Question

Reply #4

hypersoniq — Wed, 09 May 2007 01:43:19 GMT

if you are pasting straight to excel, then under the data menu item, use the Text to Columns option, this brings up the same delimiter options as importing a text file without the extra step.

Reply #3

Raven62 — Tue, 08 May 2007 00:11:50 GMT

For an example, see the following thread:

https://www.lotterypost.com/thread/155708/826141

Reply #2

Todd — Mon, 07 May 2007 23:48:15 GMT

It sounds like you have:

123 456 789

...and you want to replace it with:

123,456,789

...right?

If so, don't do the replacement in Excel. Just paste it into Notepad, then press Ctrl+H (Replace) type a space for the Find and a comma (,) for the replace. Then click Replace All.

A tip: for the quickest, most accurate responses, it is always best to include an example as I have above. It helps people understand exactly what you're looking for.

Reply #1

phileight — Mon, 07 May 2007 23:39:07 GMT

P3P

Paste your numbers into a word processor document, wordpad word etc.

save as text file

now open this file using excel use the delimited option and choose space as delimiter.

if I understood your data format this should put each 3 number group in a seperate line.

you had indicated you wanted them seperated by a comma. If that was your objective use the word processor document and use the edit function, find and replace. look for space and replace with comma. save document aga... [ More ]

Can anyone help me with an Excel Question

Pick3Place — Mon, 07 May 2007 14:32:58 GMT

The output of my P-3 software is 20, three digit numbers separated by a space between each number. I take this output and paste it into a single cell on excel. Is there then a way to get excel to separate each three digit numbers with a cama? If anyone can help we can discuss on a private message.

Thanks in advance

P3P