On 2002-03-21 13:44, TAG423 wrote:
I have large numbers in one column.
2345900-4039klj
2345900-7690lgn
2345900-3670ghl
etc.....
In the next column, I only need the last four numbers with an apostrophe in front.
'4039
'7690
'3670
etc......
What is the formula for this?
If the data is regular as your sample shows, use:
=MID(A1,SEARCH("-",A1)+1,4)
The result is a text-formatted number.
If you need the apostrophe, use:
="'"&MID(A1,SEARCH("-",A1)+1,4)