Edit text string using delimiter?

**508** · 03-14-2009, 04:26 PM

Hi all,

I have tried experimenting with LEFT, RIGHT functions. I want to edit a text string using a delimiter. For example: "NOS|NOS". I have a column of 256 rows of such entries, a name; the pipe; a name. I need to be able to strip out one side or the other using that pipe as the delimiter, leaving only "NOS". With 256 rows of items with this format - the length of the text string will vary.

I would appreciate any help.
Chris (508)

**Ron Coderre** · 03-14-2009, 05:21 PM

With a column cells containing two text values separated by pipes ( | )
Example:
A1: Alpha|Bravo
A2: Charlie|Delta
etc

Try this...
Select the single-column range of text cells
From the Excel Main Menu: Data•Text_to_Columns
Check: Delimited.......Click: Next
Check: Other...Type: | ......click Next
Select whichever side of the list you want to ignore
Check: Do not import column (skip)

To write over the current values....Click: Finish
otherwise....Select a Destination cell...then click: Finish

Does that help?

**508** · 03-14-2009, 05:28 PM

Ron,

Yes, that did the trick.

I never would have found that on my own.

Thank you very much.
Chris (508)

**mudraker** · 03-14-2009, 06:03 PM

Your post does not comply with Rule 9 of our Forum RULES. If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit. And please never edit a thread in which someone else has responded.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save