View Single Post
  #2   Report Post  
Pierre
 
Posts: n/a
Default


jerry wrote:
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


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