Triming of Names

brettvba · May 9th, 2002, 09:19 PM

I have a name

bruce mann total

assigned to a variable

How do I trim the total off the end of the variable?

The variable is ever changing but will always have total at the end!

_________________

[ This Message was edited by: brettvba on 2002-05-09 20:23 ]

Qroozn · May 9th, 2002, 09:26 PM

why dont you do a replace " total" with ""?

brettvba · May 9th, 2002, 09:31 PM

yeah no i need to do it with code just for the one variable not the whole sheet..

Ivan F Moala · May 9th, 2002, 09:31 PM

Quote:

On 2002-05-09 20:19, brettvba wrote:
I have a name

bruce mann total

assigned to a variable

How do I trim the total off the end of the variable?

The variable is ever changing but will always have total at the end!

_________________

[ This Message was edited by: brettvba on 2002-05-09 20:23 ]

How about:



sNewVar = Left(sVar, InStr(1, sVar, "total") - 1)

Where:
sNewVar is the New string Variable
sVar is you changing variable
"total" is the string to remove.

May 9th, 2002, 09:26 PM	#2
Qroozn Board Regular Join Date: Mar 2002 Location: Sydney/Brisbane , Australia Posts: 539	why dont you do a replace " total" with ""? __________________ Colin

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 9th, 2002, 09:19 PM	#1
brettvba MrExcel MVP Join Date: Feb 2002 Location: Christchurch New Zealand Posts: 1,030	I have a name bruce mann total assigned to a variable How do I trim the total off the end of the variable? The variable is ever changing but will always have total at the end! _________________ [ This Message was edited by: brettvba on 2002-05-09 20:23 ]

May 9th, 2002, 09:31 PM	#3
brettvba MrExcel MVP Join Date: Feb 2002 Location: Christchurch New Zealand Posts: 1,030	yeah no i need to do it with code just for the one variable not the whole sheet..