use the following formula in adjucant cell.
for example if your data is in column B2 then in C2 copy and paste the
following formula.
=RIGHT(B2,LEN(B2)-FIND("$",B2)+1)
once you got all the values in column C
1. copy the contents in column C
2. use Edit -> Paste special - values to paste them back in column B
Simple.
Bye
Kishan Reddy, K.
On Jul 27, 9:42 pm, flebber <flebber.c...@gmail.com> 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
--
----------------------------------------------------------------------------------
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
