Splitting part codes

[MattB]

Hi all, a simple one for somebody!
Column A shows 100's of part codes much like the one shown:
1HAT60847BC-LB16SA
I want column B to show LB16SA.
Any bright ideas?
Thanks

Matt

 

[Matt]

Try this formula in B1

=right(A1,6) and then copy formula down

 

[Aladin Akyurek]

On 2002-03-22 04:15, MattB wrote:
Hi all, a simple one for somebody!
Column A shows 100's of part codes much like the one shown:
1HAT60847BC-LB16SA
I want column B to show LB16SA.
Any bright ideas?
Thanks

Matt

In case the segment you want to extract is of variable length, use:

=RIGHT(A1,LEN(A1)-SEARCH("-",A1))

 

[Dave Hawley]

Also..

=REPLACE(A3,1,FIND("-",A3),"")

 

[Matt]

Or you could use text to columns on the data menu

- select delimited as your data type
- for your delimiter select other and enter "-"

this will also split your cells as requested