Deleting Part of a Cell in Excel/b] 2

[Texanite]

I have 4,00 rows and in one column each cell has a number, a space and the word Total after the numbers, i.e, 123456 Total. I need to get rid of the space and word total. Surely there has to be a simple way to do that.

Thanks,
Texanite

 

[carrr]

Highlight your column. Edit > Replace > type a space, then type Total into the "Find what" field and leave the "Replace with" field blank. Hit "Replace All."

"'Tis an ill wind that blows no minds." - Malaclypse the Younger

 

[SkipVought]

Hi,

Select the column

Edit/Replace -- in Find enter [space]Total ( Total) and then replace all.



Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

Skip,

http://www.TheOfficeExperts.com