Excel question

  rawsongreen 12:54 30 Jan 2010
Locked

I have a column with 3,4,5 or 6 words in each cell and the last word in each is count.
Is there a way to remove the word count in each cell?

  VoG II 13:01 30 Jan 2010

Assuming column A, in a spare column enter

=SUBSTITUTE(A1," count","")

and copy down as far as needed. Select those new values and copy them. Select your original list, Edit > Paste Special > tick Values anbd click OK.

Then delete the 'new' column.

  rawsongreen 13:23 30 Jan 2010

Vog that's magic many thanks.

  John B 13:47 30 Jan 2010

Thanks.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Best phone camera 2017

Stunning new film posters by Hattie Stewart, Joe Cruz & more

iPad Pro 10.5in (2017) review

28 astuces pour profiter au mieux de votre iPhone