How do I truncate a text field in Excel?
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". |
How do I truncate a text field in Excel?
Make sure the column adjacent to the right is empty, if not insert a new
column to the right select the column you want to split and do datatext to columns, select delimited, click next and in the other box put the pipe character then click finish. Make sure it does what you want before you save the workbook -- Regards, Peo Sjoblom "Baxter" wrote in message ... 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". |
How do I truncate a text field in Excel?
Try this:
Select the single-column range of values From the Excel Main Menu: <data<text-to-columns.....Check: Delimited......Click [Next] In the "other" box....Type the pipe symbol....Click [Finish] Does that help? Post back if you have more questions. -------------------------- Regards, Ron (XL2003, Win XP) Microsoft MVP (Excel) "Baxter" wrote in message ... 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". |
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". |
All times are GMT +1. The time now is 10:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com