deleting partial data in column

**joelw** · 10-06-2008, 10:41 PM

can you just delete part of a cell but like 3000 rows at a time? For example i have a column that says this:

http://www.watchwholesalers.com/webs.../350/78651.jpg all the way down the worksheet. My question is can you delete just the http://www.watchwholesalers.com/webs...oduct/200/350/ and leave just the 78651.jpg but as a group delete or do you have to do each one individually. Please if anyone can help me i would realy appreciate it.

**NBVC** · 10-06-2008, 10:46 PM

If it is exactly the same piece of text you want to delete from each line, then copy the part you want deleted and go to Edit|Replace.... paste the text into the Find What field and leave the other field blank. Click Replace All.

**sglife** · 10-06-2008, 11:41 PM

for your sample, try this
Select all the ranges

Please Login or Register  to view this content.

**nsv** · 10-07-2008, 11:35 AM

Assuming all your .jpg files are 5 digit numbers and that they are located in column A, then the easiest way is to write in the neighbouring column B

Please Login or Register  to view this content.

and copy that cell all the way down to B3000

If this is not the case, but you have the same number of slashes then you can mark up all the 3000 cells and go:
Data - Text to Columns - Delimited - and enter a '/' in 'Other'.

NSV

**Cheeky Charlie** · 10-07-2008, 12:05 PM

I like the sglife solution - if you wanted to keep the original column you could also use this:

=RIGHT(A1,LEN(A1)-FIND(CHAR(1),SUBSTITUTE(A1,"/",CHAR(1),LEN(A1)-LEN(SUBSTITUTE(A1,"/","")))))

to deliver the last part of a path type string

HTH