Text to Columns Help

M

MarkHuether

Can someone show me how to convert a column of data filled with information
like this:
2.756.00-9,86259,172.00-45,953275,718.00

to 6 columns like this:

2.75 6.00 -9,862 59,172.00 -45,953 275,728.00
 
D

dlw

You could use the =MID function to chop it up, BUT, the formats of all 6
numbers would have to be the same all the time.

for example =MID(a1,5,4) would give you 6.00, but that number would always
have to start in the 5th position and be 4 characters long.
 

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