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,

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

"NicoleS" wrote:

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,

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

On Dec 4, 6:25*pm, NicoleS wrote:
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,

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

"Pete_UK" wrote:

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

On Dec 4, 6:25 pm, NicoleS wrote:
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,

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 :)

"Dave" wrote:

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

"NicoleS" wrote:

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,

You're welcome, Nicole.

Pete

On Dec 4, 8:23*pm, NicoleS wrote:
Thanks! The number of characters varies, but not frequently. This may do the
trick :)



"Pete_UK" wrote:
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

On Dec 4, 6:25 pm, NicoleS wrote:
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,- Hide quoted text -

- Show quoted text -