Removing parts of Data in a Cell / [], #
 

I have date that is copied from another program (similar to notebook) and
pasted into excel. I perform text to colums and end up with ALMOST whta I
need. The problem is that two colums are not exactly right.

One colum shows four digit numbers with brackets [1234]. I need to keep the
number, but remove the brackets.
The second column has a string of numbers with #in front #12345678. I need
to keep the number string, but remove the # symbol.

Thanks

Removing parts of Data in a Cell / [], #
 

Use "Edit", "Replace" (and leave Replace with blank)
--
If my posting was helpful, please click the "Yes" button.

ROCK ON!,

Scott


"Teddy-B" wrote:

I have date that is copied from another program (similar to notebook) and
pasted into excel. I perform text to colums and end up with ALMOST whta I
need. The problem is that two colums are not exactly right.

One colum shows four digit numbers with brackets [1234]. I need to keep the
number, but remove the brackets.
The second column has a string of numbers with #in front #12345678. I need
to keep the number string, but remove the # symbol.

Thanks

Removing parts of Data in a Cell / [], #
 

=MID(A2,2,LEN(A2)-2) for the first
=RIGHT(A2,LEN(A2)-1) for the second
--
David Biddulph


"Teddy-B" wrote in message
...
I have date that is copied from another program (similar to notebook) and
pasted into excel. I perform text to colums and end up with ALMOST whta I
need. The problem is that two colums are not exactly right.

One colum shows four digit numbers with brackets [1234]. I need to keep
the
number, but remove the brackets.
The second column has a string of numbers with #in front #12345678. I need
to keep the number string, but remove the # symbol.

Thanks