splitting numbers

M

miki peric

Hi, I need help with splitting numbers. I got the numbers in excel in each cell like this:
A1: 0000 02 1.884308
A2: 6 02 1.092346
......
and need to put each number in a cell like:
A1: 0000 B1:02 C1: 1.884308
A2: 6 B2:02 C2: 1.092346

if someone can help me it would be great because i have a lots of data to split in three columns. thanks

EggHeadCafe - .NET Developer Portal of Choice
http://www.eggheadcafe.com
 
L

Lars-Åke Aspelin

A1: 0000 02 1.884308
A2: 6 02 1.092346


Try using "Text to Columns" and specify that your data are delimited
by Space and Treat consecutive delimiters as one.

Hope this helps / Lars-Åke
 
R

Ron Rosenfeld

Hi, I need help with splitting numbers. I got the numbers in excel in each cell like this:
A1: 0000 02 1.884308
A2: 6 02 1.092346
.....
and need to put each number in a cell like:
A1: 0000 B1:02 C1: 1.884308
A2: 6 B2:02 C2: 1.092346

if someone can help me it would be great because i have a lots of data to split in three columns. thanks

EggHeadCafe - .NET Developer Portal of Choice
http://www.eggheadcafe.com


Select A1:A2

Select Data/Text-to-columns
Delimited
Next
Space
Treat Consecutive Delimiters as one
Next
Column Data Format
For Columns 1 & 2, select TEXT
Finish
--ron
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top