2 data sets in one cell

[Guest]

Hi All,

I've copy and pasted some data into excel for exchange rates over the past
years. The format that the data is in has the US$ - CDN$ and the CDN$ - US$
rate in the same cell. It looks like "1.53948182 [ 0.64956922 ]". I want to
automatically put the exchange rate that is in brackets into the column next
to it while keeping the other one in its current cell. Is there anyway to do
this automatically?

Thanks!

 

[Dave Peterson]

So you're going to put each figure it its own cell.

I'd select the column
edit|replace
what: [
with: _ (spacebar)
replace all
(and once more)
edit|replace
what: ]
with: _ (spacebar)
replace all

Then your figures will be separated/surrounded by spaces.

Then with that column still selected
data|text to columns|delimited|by space
and check that "treat consecutive delimiters as one"

And finish up.

Hi All,

I've copy and pasted some data into excel for exchange rates over the past
years. The format that the data is in has the US$ - CDN$ and the CDN$ - US$
rate in the same cell. It looks like "1.53948182 [ 0.64956922 ]". I want to
automatically put the exchange rate that is in brackets into the column next
to it while keeping the other one in its current cell. Is there anyway to do
this automatically?

Thanks!