flebber wrote:
> I have a column containing cells which house several delimited values
> and a dollar value. I want to be able to remove the delimited values
> and leave the dollar value in the cell in currency format.
>
> the cells contain information similar to
>
> 22-7-4-7 $22400.10
If this text is in cell A1, you can enter the following formula into
some other cell and retrieve the dollar value from A1. Then you can
format the new cell as currency manually (you can do this for lots of
cells in one go).
=RIGHT(A1,LEN(A1) - FIND("$",A1))
Regards,
Stuart
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 7000 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
