Posted to microsoft.public.excel.programming

steven

external usenet poster

Posts: 389

Formula = problem

Got it. Thank you.

"ward376" wrote:

You have a missing left parentheses and an extraneous dash in there.

Try recording the entry of the formula - you'll get something like
this...

Range("e5").FormulaR1C1 = _
"=MID(R[7]C,
1+FIND(CHAR(1),SUBSTITUTE(R[7]C,""\"",CHAR(1),LEN(R[7]C)-
LEN(SUBSTITUTE(R[7]C,""\"","""")))),255)"

Cliff Edwards

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
Formula problem	a	Excel Discussion (Misc queries)	1	December 2nd 09 06:20 PM
Formula Problem	Mark Hanson	Excel Discussion (Misc queries)	2	September 12th 07 05:17 PM
Formula problem	superkopite	Excel Discussion (Misc queries)	8	January 27th 06 09:12 PM
formula problem	Bart	New Users to Excel	4	October 21st 05 12:56 PM
Problem with formula	Sundaram Iyer	Excel Discussion (Misc queries)	0	June 1st 05 12:49 AM

All times are GMT +1. The time now is 05:53 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us