Delete certain text from cells

U

ukat101052

I have a column of data (>50 cells), with some cells blank. In certain
of the cells, there is a dash that separates the first word in the cell,
and the remaining letters/text (actually it is a blank/-/blank). I
would like VBA that would delete everything after the first word in the
cell (and this word can vary in length). Any ideas?
Thanks in advance.
 
C

Claus Busch

Hi,

Am Wed, 30 Jan 2013 18:12:03 +0000 schrieb ukat101052:
I have a column of data (>50 cells), with some cells blank. In certain
of the cells, there is a dash that separates the first word in the cell,
and the remaining letters/text (actually it is a blank/-/blank). I
would like VBA that would delete everything after the first word in the
cell (and this word can vary in length). Any ideas?
Click to expand...

home tab => Find & Select => Replace
Find what: blank-blank*
Replace with: Nothing


Regards
Claus Busch
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can't seem to delete all images from a Word Doc 2
Select Text to End of Footnote 9
Cumulative formula for word table 0
Merging from an Excel file with graphics 1
Word VBA - Delete text from bulleted paragraphs 1
Code to cut a paragraph that's followed by a table 2
Auto Merge text from multiple sources 0
Problem with SET & REF function 0

Top