Text to Columns Help
 

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

Text to Columns Help
 

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.

"MarkHuether" wrote:

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

Text to Columns Help
 

If excel 2007, go to dataText to Columns fixed widthread instructions
break linesfinish

"MarkHuether" wrote:

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

Text to Columns Help
 

Perhaps it's a Fixed Width text file?

MarkHuether wrote:

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