Can someone help with an Excel question

Reply #3

winsumloosesum — Sun, 13 May 2007 19:52:14 GMT

This is a link to an excel file with User Defined Function (UDF)

http://rapidshare.com/users/K89UOL

Reply #2

winsumloosesum — Sun, 13 May 2007 19:02:34 GMT

If all 20 numbers are in Cell A1

If you want to put all 20 combos in cell B1 and replace the spaces with a comas here is the formula you place in cell B1

=LEFT(SUBSTITUTE(A1, , , ),LEN(A1)-1

Reply #1

CARBOB — Mon, 07 May 2007 16:22:28 GMT

Put cursor In the first cell where your data is located, make sure the next 9 columns to the right are empty!! Click Data- Text to Columns, follow instructions!!

Hope this helps.

Can someone help with an Excel question

Pick3Place — Mon, 07 May 2007 15:47:59 GMT

My P-3 software outputs 20 three didget numbers separated by a space between each pick.

I paste this output into a single cell on excel. So within this cell there are 20 3 digit numbers.

Example:

167 169 160 179 170 679 853 190 352 670

453 690 852 458 790 832 452 843 432 842

Is there a way then to get excel to comma diliniate these 20 three digit numbers.

Thanks in advance

P3P