Menu

Extract Part of Sentence for Separate Cell's Value

Search this Thread

Prev

Previous Post

Next Post

Next

#4

Report Post

Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheetfunctions

Ron Rosenfeld Ron Rosenfeld is offline

Ron Rosenfeld is offline

external usenet poster

Posts: 5,651

Default

Extract Part of Sentence for Separate Cell's Value

On 21 Dec 2006 06:54:54 -0800, wrote:

Hello Gents/Ladies...another question....

I have a cell, C13, that says:

Bonus: $4,000 (DEC06).

My question:
How can I copy just 4,000 from this cell and make K18 say $4,000.

FYI, C13 does not always contain this data, just sometimes. I need
something that would look for the dollar amount and copy only the
dollar amount to K18.

Thanks for all your help, I really appreciate your time.

:o)
Bull

Your specifications are incomplete. In particular, you do not indicate what
you wish to happen should the data you describe not be in the cell.

To copy the value 4000 (not the text string 4,000) to cell K18 and "make K18
say" $4,000:

1. Format K18 as currency with zero decimal places.
2. Put the following formula in K18:

=--MID(C13,FIND("$",C13)+1,FIND(" ",C13,
FIND("$",C13)+1-FIND("$",C13))-1)

This formula will give a VALUE error if C13 does not contain the appropriate
data. But you'll have to tell us what you want to happen in that instance.

--ron

Reply With Quote

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
Replacing Part of a Cell's Content	mommy2kh	Excel Worksheet Functions	5	July 13th 08 05:42 PM
How I separate first two letters of the sentence in msexcel	Ubaid Yousuf	Excel Discussion (Misc queries)	2	May 16th 08 09:23 PM
Extract all letters from a cell sentence	michaelxhermes	Excel Worksheet Functions	5	December 14th 07 06:59 PM
separate a Capital starting word from a sentence	Rasoul Khoshravan	Excel Worksheet Functions	3	October 25th 06 06:31 PM
Extract the n word of a sentence in a cell	crazy_vba[_3_]	Excel Programming	6	April 22nd 06 06:53 PM

All times are GMT +1. The time now is 01:56 PM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement