Posted to microsoft.public.excel.programming

HLS[_2_]

external usenet poster

Posts: 1

Replace and Substitute Functions

I'm using both of the fuctions to correct the european number format, but I
can't seem to get the syntax right.

What am I doing wrong?

Range("G" & x + 3).Activate
WorksheetFunction.REPLACE(G" & x &",Right("G" & x,1),1,"")
WorksheetFunction.Substitute(G & x,LEFT(G & x + 3),""-""&LEFT(G & x +
3),1)

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
wildcards with substitute of replace	Jay Fincannon	Excel Programming	5	September 16th 06 07:24 PM
Replace/substitute	Viktor Ygdorff	Excel Programming	0	July 17th 06 02:35 PM
Substitute/Replace	Viktor Ygdorff	Charts and Charting in Excel	0	July 17th 06 12:37 PM
Looking for a site with functions that substitute the ATP functions	Franz Verga	Excel Worksheet Functions	3	June 24th 06 04:30 AM
Replace or Substitute for COMBIN function	Jaja	Excel Discussion (Misc queries)	6	January 1st 06 02:18 PM

All times are GMT +1. The time now is 01:26 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us