How do I truncate a text field in Excel?
Depending upon the elements.................
DataText to ColumnsDelimited byOther.
Enter the pipe and Next to see what you get.
If dealing with dates or numbers with a preceding 0 you should go to Next and
Format Data Column.
Select Date or Text
If looks OK hit Finish.
Gord Dibben MS Excel MVP
On Wed, 26 Sep 2007 16:06:00 -0700, Baxter
wrote:
I have a field with two data elements, separated by a | (pipe symbol). I
would like to populate the 1st half into one cell, and the 2nd half into
another cell. This is the opposite of the Excel function "Concatenate".
|