Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trim or Extract from a Text Field
Within Excel, how do I either trim the characters in a text field or extract
characters? I have a field that is in the xxxxxxyyyyxxxxx format and need only the yyyy portion. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trim or Extract from a Text Field
With in cell A1
If you want to extract those yyyy characters using a formula.... try this: B1: =MID(A1,7,4) OR...you could use Text-to-Columns: Select the single column range of values (eg: A1:A10) From the Excel Main Menu: <data<text-to-columns Check: Fixed Width Click [Next] Insert break points before and just after the yyyy chars (by clicking) Click [Next] Select the 1st column.....Click: Do not import column Select the 3rd column.....Click: Do not import column Then....you have a decision: To trim the excess characters from the actual cells...Click [Finish] To extract the yyyy chars to another location: Set the Destination cell (eg B1)....Click [Finish] Does that help? -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "billbrandi" wrote in message ... Within Excel, how do I either trim the characters in a text field or extract characters? I have a field that is in the xxxxxxyyyyxxxxx format and need only the yyyy portion. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text to Columns or TRIM? | Excel Discussion (Misc queries) | |||
Extract only numbers from an alphanumeric field in Excel? | Excel Discussion (Misc queries) | |||
Extract last name and insert into a different field. | Excel Worksheet Functions | |||
text trim combine | Excel Discussion (Misc queries) | |||
Extract Portion of field into other fields | Excel Worksheet Functions |