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
|