Separating text in a cell

  • Thread starter Thread starter Aaron
  • Start date Start date
A

Aaron

Hi,

Is there a function opposite to concatenate that splits text in a cell?

Thanks
 
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
 
Maybe a combination of =search(), =find(), mid(), =left() and =right() would
work.

Or if your data is laid out nicely, you could use:
data|text to columns (xl2003 menu system)

If the data is delimited or fixed width, this method is very fast.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

TRIM IF CELL CONTAINS ONE WORD, ABBREVIATE IF IT CONTAINS MULTIPLE WORDS 1
How specify number format of cell value in concatenate function? 1
How do I truncate a text field in Excel? 2
Use reference text from one cell in another function call 3
Constructing Range Name calls with Concatenate 4
Looking for code to separate one line of text into multiple lines in Excel 1
cell extract 2
if then statement to return text from cells satisfying condition 2

Back
Top