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

[Teddy-B]

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

 

[porter444]

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

ROCK ON!,

Scott

 

[David Biddulph]

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