replace text string

Qroozn · Apr 2nd, 2002, 09:13 PM

I am trying to replace a cell value text string
the cell value is
" 1 ASD 4 PIZZA 00000 3 Dogs"
i want a formula in the next cell that strips off all the 0's...
without a VB code. to leave
" 1 ASD 4 PIZZA 3 Dogs"
any ideas?

Dave Hawley · Apr 2nd, 2002, 09:25 PM

Hi

How about

=SUBSTITUTE(A1,"0","")

Qroozn · Apr 2nd, 2002, 10:12 PM

Perfect.
thanks dave..
Stupid me was looking for replace not substitute.

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

Apr 2nd, 2002, 09:13 PM	#1
Qroozn Board Regular Join Date: Mar 2002 Location: Sydney/Brisbane , Australia Posts: 539	I am trying to replace a cell value text string the cell value is " 1 ASD 4 PIZZA 00000 3 Dogs" i want a formula in the next cell that strips off all the 0's... without a VB code. to leave " 1 ASD 4 PIZZA 3 Dogs" any ideas?

Apr 2nd, 2002, 09:25 PM	#2
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi How about =SUBSTITUTE(A1,"0","")

Apr 2nd, 2002, 10:12 PM	#3
Qroozn Board Regular Join Date: Mar 2002 Location: Sydney/Brisbane , Australia Posts: 539	Perfect. thanks dave.. Stupid me was looking for replace not substitute.