I need some help trimming text.

Dilemma: I want to remove the number coding in front of the state code so
that in column B in range B1:B3, I have California/Ohio/Maryland without the
numbers. How do I trim the first four characters in the cell range A1:A3?

Col A
001-California
002-Ohio
003-Maryland

Col B - desired result
California
Ohio
Maryland

=MID(A1,FIND("-",A1)+1,255)

and copy down.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Scott" wrote in message
...
I need some help trimming text.

Dilemma: I want to remove the number coding in front of the state code so
that in column B in range B1:B3, I have California/Ohio/Maryland without
the
numbers. How do I trim the first four characters in the cell range A1:A3?

Col A
001-California
002-Ohio
003-Maryland

Col B - desired result
California
Ohio
Maryland

Scott

Try this:

=RIGHT(A1,LEN(A1)-4)

bob

"Scott" wrote:

I need some help trimming text.

Dilemma: I want to remove the number coding in front of the state code so
that in column B in range B1:B3, I have California/Ohio/Maryland without the
numbers. How do I trim the first four characters in the cell range A1:A3?

Col A
001-California
002-Ohio
003-Maryland

Col B - desired result
California
Ohio
Maryland

If your example is representative you could use DataText to ColumnsDelimited
by "-"

If you want to keep original column A just copy it to B then run the text to
columns and in step 3 select 1st column to skip.


Gord Dibben MS Excel MVP

On Fri, 15 Dec 2006 12:11:01 -0800, Scott
wrote:

I need some help trimming text.

Dilemma: I want to remove the number coding in front of the state code so
that in column B in range B1:B3, I have California/Ohio/Maryland without the
numbers. How do I trim the first four characters in the cell range A1:A3?

Col A
001-California
002-Ohio
003-Maryland

Col B - desired result
California
Ohio
Maryland

Could he not just select the column and do a replace (without the quotes)
"*-" ?


"Scott" wrote in message
...
I need some help trimming text.

Dilemma: I want to remove the number coding in front of the state code so
that in column B in range B1:B3, I have California/Ohio/Maryland without
the
numbers. How do I trim the first four characters in the cell range A1:A3?

Col A
001-California
002-Ohio
003-Maryland

Col B - desired result
California
Ohio
Maryland