Opposite of concatenate

[sburkhar]

Is there an opposite function? If so, what is it called?

 

[Firefly2012]

Not in native Excel functions (unless you mean MID() or LEFT() or RIGHT()). Can you provide context and an example, then we can probably suggest something.

 

[sburkhar]

I would like to isolate the last two digits in this:
000-56050505-F-010-01

 

[CalvinTy]

Is there an opposite function? If so, what is it called?

Although I am here for assistance for my own question about concatenate (and rank function), I can answer that question somewhat.

In Excel 2007, the opposite would be in Data ribbon, Data Tools group, and selecting "Text to Columns". This will separate data into different columns.

Is that what you are looking for?

Regards,

* CalvinTy

 

[CalvinTy]

I would like to isolate the last two digits in this:
000-56050505-F-010-01

In that case, just do the RIGHT function that Firefly2012 just mentioned:

RIGHT(text,2)

The "text" being the cell you want to be referred;
the "2" being the number of characters from the right to be displayed in the new cell

Cheers,

* CalvinTy

 

[sburkhar]

actually - I just did it with the =right formula. But i'm definitely going to look at the text to column function.
Thanks!