Prev: Pallets w/varying sizes & weights need to fit in restricted space
Next: VLookup to bring in not true data.
From: MarkHuether on 28 Apr 2010 14:43
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
From: dlw on 28 Apr 2010 15:02
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
From: Narnimar on 28 Apr 2010 15:15
If excel 2007, go to data>Text to Columns >fixed width>read instructions
>break lines>finish

"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
From: Bob I on 28 Apr 2010 16:05
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

 | 
Pages: 1
Prev: Pallets w/varying sizes & weights need to fit in restricted space
Next: VLookup to bring in not true data.