Try this formula in B1
=right(A1,6) and then copy formula down
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: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
=RIGHT(A1,LEN(A1)-SEARCH("-",A1))
Also..
=REPLACE(A3,1,FIND("-",A3),"")
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
Like this thread? Share it with others