Deliminating Text

[NicoleS]

I need to deliminate text, but not all of it.
Example: Let's say this is a part number:
1234-AB-20GQ

If I need to keep the 1234-AB together, and just drop off the 20GQ... Is
there a way to do that?

Currently I use deliminator, set it to deliminate hyphens (-) and then
concatonate the pieces I need back together.

Thanks,

 

[Dave]

Try this...

Go to Edit, then click on Replace...

Put in the Find - 1234-AB
Put in the Replace with- 1234-AB

Then click, replace or replace all.

If this does not work let me know and I will attempt to fix it by
delimination.
-D

 

[Pete_UK]

If the first part of your code is always 7 characters, then you could
use:

=LEFT(A1,7)

and copy down.

Hope this helps.

Pete

 

[NicoleS]

Thanks! The number of characters varies, but not frequently. This may do the
trick

 

[NicoleS]

I never thought of this. This would work well when I have a long list of part
numbers that vary only with the color code at the end. Thanks

 

[Pete_UK]

You're welcome, Nicole.

Pete

Thanks! The number of characters varies, but not frequently. This may do the
trick






- Show quoted text -