select part of a cell value string

Hi,

I have a column of text (postcodes/zipcodes) in the following formats L3*1MT
or L12*3DE. What i want to do is have a second column that reads the first
column value and removes the *data, leaving just the L3 or L12. How can i do
this??

Thanks

Rich

Hi Rich,

Try this

=LEFT(A1,FIND("*",A1)-1)

--
HTH

Bob Phillips

"rich_j_h" <[email protected]> wrote in message
news:[email protected]...
> Hi,
>
> I have a column of text (postcodes/zipcodes) in the following formats
L3*1MT
> or L12*3DE. What i want to do is have a second column that reads the
first
> column value and removes the *data, leaving just the L3 or L12. How can i
do
> this??
>
> Thanks
>
> Rich

=LEFT(A1,FIND("*",A1)-1)

HTH
Jason
Atlanta, GA

"rich_j_h" wrote:

> Hi,
>
> I have a column of text (postcodes/zipcodes) in the following formats L3*1MT
> or L12*3DE. What i want to do is have a second column that reads the first
> column value and removes the *data, leaving just the L3 or L12. How can i do
> this??
>
> Thanks
>
> Rich