"Bob Zimski" wrote:
I need to drop the 'Rev: 2' portion in the cell to the right and the
existing cell needs to end up with 'ARD010' without any spaces.

Ostensibly, try:

=left(A1,find(" ",A1)-1)

That assumes there are no spaces __before__ the part number. Alternatively:

=trim(left(A!,find(" ",A1)-1))

Both assume that the white space between part number and revision are true
blanks. If the above formula does not work, post back here to solve the
problem.


------ original message -----

"Bob Zimski" wrote in message
...
I have a cell which contains a part number and a revision level in the
format
'ARD010 Rev: 2'. I need to drop the 'Rev: 2' portion in the cell to
the
right and the existing cell needs to end up with 'ARD010' without any
spaces.

Any help appreciated.

Bob

if there are spaces before then the formula should be

=left( TRIM(A1) ,find(" ",TRIM(A1) )-1)

"JoeU2004" wrote in message
...
"Bob Zimski" wrote:
I need to drop the 'Rev: 2' portion in the cell to the right and the
existing cell needs to end up with 'ARD010' without any spaces.

Ostensibly, try:

=left(A1,find(" ",A1)-1)

That assumes there are no spaces __before__ the part number.
Alternatively:

=trim(left(A!,find(" ",A1)-1))

Both assume that the white space between part number and revision are true
blanks. If the above formula does not work, post back here to solve the
problem.


------ original message -----

"Bob Zimski" wrote in message
...
I have a cell which contains a part number and a revision level in the
format
'ARD010 Rev: 2'. I need to drop the 'Rev: 2' portion in the cell to
the
right and the existing cell needs to end up with 'ARD010' without any
spaces.

Any help appreciated.

Bob