Posted to microsoft.public.excel.worksheet.functions

Bernd P

external usenet poster

Posts: 806

How can I extract the second half of addition ?

Hello,

Ron's VBA solution might seem preferrable but there is a non-VBA
solution:
Define the name SecSumPar, for example, which refers to:
=MID(GET.CELL(6,INDIRECT("RC[-1]",FALSE)),1+LOOKUP(2,1/
("+"=MID(GET.CELL(6,INDIRECT("RC[-1]",FALSE)),ROW(INDIRECT("1:"&LEN(GET.CELL(6,INDIREC T("RC[-1]",FALSE))))),
1)),ROW(INDIRECT("1:"&LEN(GET.CELL(6,INDIRECT("RC[-1]",FALSE)))))),
999)

Then insert into the next cell right to your cell with =3+4:
=SecSumPar
and you will get
4

Regards,
Bernd

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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
print half of rows on left and other half on right	Steve B.	Excel Discussion (Misc queries)	2	November 16th 07 11:20 AM
Addition?	Frodo	Excel Discussion (Misc queries)	3	July 22nd 06 01:15 PM
addition	dali	New Users to Excel	1	March 4th 06 06:40 PM
Extract Unique Values, Then Extract Again to Remove Suffixes	Karl Burrows	Excel Discussion (Misc queries)	23	June 25th 05 10:37 PM
row addition	Threshold	Excel Worksheet Functions	3	March 17th 05 08:08 PM

All times are GMT +1. The time now is 02:10 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us