| View previous topic :: View next topic |
| Author |
Message |
fivefootnine
Power User
Joined: 09 Apr 2012
Posts: 60
|
 Posted: Wed Jun 27, 2012 10:21 am Post subject: Divide numbers into separate cells |
 |
|
Let´s say I have a list of 20 numbers in A1 separated by spaces,I would like to send them to separate cells, so that each number will have it´s own cell (A1-T1)?
Any method on how to solve this problem would be appreciated.
Thanks |
|
| Back to top |
|
 |
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
Location: Germany
|
| Posted: Wed Jun 27, 2012 10:49 am Post subject: |
|
|
How do these strings get into the cells?
Why don't you put them into separate cells in the first place?
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org |
|
| Back to top |
|
|
fivefootnine
Power User
Joined: 09 Apr 2012
Posts: 60
|
| Posted: Wed Jun 27, 2012 11:16 am Post subject: |
|
|
Someone else created the numbers I just want to separate them. The list consists of +100 rows of 20 numbers each.
An example of the list,
IN A1 [ ] = Cell
[ 3 5 14 23 45 76 21 34 56 89 4 12 11 7 34 89 93 16 15]
I want to splice the numbers into separate cells , like this [ ] = cell
[3] [5] [14] [23] [45]......
Any advice is appreciated.
Last edited by fivefootnine on Wed Jun 27, 2012 11:19 am; edited 1 time in total |
|
| Back to top |
|
|
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
Location: Germany
|
| Posted: Wed Jun 27, 2012 11:18 am Post subject: |
|
|
menu:Data>Text to columns
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org |
|
| Back to top |
|
|
fivefootnine
Power User
Joined: 09 Apr 2012
Posts: 60
|
| Posted: Wed Jun 27, 2012 11:20 am Post subject: |
|
|
| Thank you for you fast reply! |
|
| Back to top |
|
|
|
