Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with Formula
I have a column that each cell ends with the word "Total". I need to convert
that column to remove that word from each cell. If I need to add a column to do that, that's fine, I just cannot figure out how. Can anyone help me on this one? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with Formula
How about just selecting the column and using Edit|replace
What: Total (or spacebar total???) with: (leave blank) replace all cware wrote: I have a column that each cell ends with the word "Total". I need to convert that column to remove that word from each cell. If I need to add a column to do that, that's fine, I just cannot figure out how. Can anyone help me on this one? Thanks -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with Formula
cware,
There are a couple ways to do this. If you are looking to just remove the word "Total", do a simple Replace (EditReplace) For:Total To:<nothing. Or formulaically: =TRIM(LEFT(A1,(LEN(A1)-5))) Trim will remove any additional spaces. -- --Thomas [PBD] Working hard to make working easy. "cware" wrote: I have a column that each cell ends with the word "Total". I need to convert that column to remove that word from each cell. If I need to add a column to do that, that's fine, I just cannot figure out how. Can anyone help me on this one? Thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with Formula
Hi,
select the column then Edit|Replace Enter Total in the 'Find what' box and leave the other box blank Click replace all Mike "cware" wrote: I have a column that each cell ends with the word "Total". I need to convert that column to remove that word from each cell. If I need to add a column to do that, that's fine, I just cannot figure out how. Can anyone help me on this one? Thanks |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with Formula
Hi
in an adjacent column =--(TRIM(SUBSTITUTE(A1,"Total",""))) Copy down as required -- Regards Roger Govier "cware" wrote in message ... I have a column that each cell ends with the word "Total". I need to convert that column to remove that word from each cell. If I need to add a column to do that, that's fine, I just cannot figure out how. Can anyone help me on this one? Thanks |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with Formula
EditReplace
What: Total With: nothing Replace all. Gord Dibben MS Excel MVP On Tue, 30 Sep 2008 11:18:07 -0700, cware wrote: I have a column that each cell ends with the word "Total". I need to convert that column to remove that word from each cell. If I need to add a column to do that, that's fine, I just cannot figure out how. Can anyone help me on this one? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|