Separating A String of Numbers

Reply #7

SergeM — Sun, 22 Feb 2015 20:20:02 GMT

5236584432695390201402736 1 2 3 4 5 6 7 8 9 10 11 12 13

523 658 443 269 539 020 140 273 6

You use mid() with referencing to other Cells.

If you need a number coming out, then make it a value.

Reply #6

lotteryfanatic — Sat, 21 Feb 2015 22:32:36 GMT

Thank-you so much Sir. I'm still working on it trying to get it to work.

Reply #5

MrProgrammer — Sat, 21 Feb 2015 19:31:42 GMT

Ok, here you go. Did it first with no programming, but a headache, so better a program function.

In your excel spreadsheet, do a Alt PF11. Pick Insert Module from top, a window will open up.

Copy the below 2 functions, and paste them in there.

Then go back to your spreadsheet, and put in either:

=LFSplitSpace(A1) Where A1 is the cell with your string

to get what you asked for separate by a space.

Or

=LFSplitComma(A1) Where A1 is the cell with your string

to ge... [ More ]

Reply #4

lotteryfanatic — Sat, 21 Feb 2015 18:28:03 GMT

Thanks a million

Reply #3

MrProgrammer — Sat, 21 Feb 2015 18:20:45 GMT

Yes, saw it about 20 minutes ago, then checked out your profile, and saw this post, so asked that question here, so saw both. 2010, ok thanks. Will have soon, and will answer both places.

Reply #2

lotteryfanatic — Sat, 21 Feb 2015 18:17:06 GMT

I'm using 2010. Did you see the message I sent you

Reply #1

MrProgrammer — Sat, 21 Feb 2015 18:07:08 GMT

Sure, what version of excel are you using

Separating A String of Numbers

lotteryfanatic — Sat, 21 Feb 2015 17:20:57 GMT

Is there anybody that could program a system in excel form that would separate a mathematical string of numbers like this:

5236584432695390201402736

into this:

523 236 365 658 etc....

The string could contain as little as 7 digits or as many as 90 digits.