Excel Help

[moss]

Hi,
Ive got an Excel worksheet with 63000 products on, and every item has a Part No and Description. The problem is the part no is repeated in the description field as shown below,
Is there any way to automatically remove the part no from the description field?

Part No          Description
A1               A1 Product 1
A2               A2 Product 2

 

[div0]

Assuming "Part Number" is column A and "Description" is Column B, try this in Column C....

=RIGHT(B1, LEN(B1)-LEN(A1)-1)

It basically counts the number of characters in the "Decription" field (LEN(B1)) and the number of charactes in the "Part Number" (LEN(A1)).

It then takes the "Description" (B1) and removes the first "n" letters from the left. Where "n" = "LEN(B1)-LEN(A1)-1" (the extra -1 is to account for the first "space", that I assume you'll want to remove too)

Try it - it should work

 

[div0]

also you might find this helpful - I can never remember some of the commands to do this stuff, so I often end up googling it!

http://office.microsoft.com/en-us/assistance/HP052032091033.aspx

 

[moss]

Thanks, done exactly what I wanted it to do

 

[div0]

No probs