Text to Columns Help

  • Thread starter Thread starter MarkHuether
  • Start date Start date
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
 
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.
 
Back
Top