Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Truncating text field in column
I have a text field in an Excel spreadsheet with (for instance) 10
characters. I wish to truncate the first 5 characters and leave the rest. Is there an easy way to do that in Excel? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Truncating text field in column
Select the column/field.
(xl2003 menu system) Data|Text to columns Fixed width draw a line between the 5th and 6th characters erase any other line that excel may have guessed Choose "Skip/Do not import" for the first portion of that field and finish up that wizard. Anne wrote: I have a text field in an Excel spreadsheet with (for instance) 10 characters. I wish to truncate the first 5 characters and leave the rest. Is there an easy way to do that in Excel? -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Truncating text field in column
=RIGHT(A1,LEN(A1)-5)
-- David Biddulph "Anne" wrote in message ... I have a text field in an Excel spreadsheet with (for instance) 10 characters. I wish to truncate the first 5 characters and leave the rest. Is there an easy way to do that in Excel? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
text truncating | Excel Discussion (Misc queries) | |||
truncating text | Excel Discussion (Misc queries) | |||
Truncating a text string | Excel Worksheet Functions | |||
Truncating a text string | Excel Discussion (Misc queries) | |||
15 character field truncating | Excel Discussion (Misc queries) |