Fx needed

MikeyZ

Well-known Member
Joined
Mar 14, 2002
Messages
553
"OSV TO BULK ANODIZE RED"

<tbody>
</tbody><colgroup><col></colgroup>

What fx can I use to get rid of the "OSV TO " and only show the rest.
 

Some videos you may like

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

JackDanIce

Well-known Member
Joined
Feb 3, 2010
Messages
9,684
Office Version
  1. 365
Platform
  1. Windows
Alt suggestion, try:
Code:
=SUBSTITUTE(A1, "OSV TO ", "")
where A1 contains "OSV TO BULK ANODIZE RED"
 

Watch MrExcel Video

Forum statistics

Threads
1,109,073
Messages
5,526,655
Members
409,713
Latest member
roman9980

This Week's Hot Topics

Top