importing data from access

J

jerry

when importing data from access, i have one column is a unique identifying
number. HOwever, the number comes in with { } around the #. How can i remove
them.

thanks
Jerry
 
P

Pierre

jerry said:
when importing data from access, i have one column is a unique identifying
number. HOwever, the number comes in with { } around the #. How can i remove
them.

thanks
Jerry
Click to expand...

Once in Excel, do a find and replace. Twice, once for {, and then
repeat for }.

Leave the "replace with" blank, and "replace all" both times.

pierre
 
D

Dave Peterson

I don't speak Access, but couldn't you just select your range and do:
Edit|Replace
what: {
with: (leave blank)
replace all
then once more for the close bracket }
 
Top