Separating text in a cell
hi
there are 3. =right(), =mid() and =left()
=right() returns a number of characters that you specify in a cell starting
from the right side.
=left() does the same but starts from the left side of the data.
=mid() returns characters from the middle of the cell given a start point
and number of characters.
there is also text to columns
on the menu bar...
data.Text to columns...follow the wizard.
see help on all of the above for more details.
regards
FSt1
"Aaron" wrote:
Hi,
Is there a function opposite to concatenate that splits text in a cell?
Thanks
|