Have a look in the help index for SUBSTITUTE
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Amit Desai (MERU)
Sent: Tuesday, July 31, 2012 8:39 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Remove Extrict sign & replce by L
Dear Friends,
Please note that I would like to have a formula that would remove * sign from
the text & will replace it by L. Following is the sample data. Please help.
Code Number
Result needed
1234*
1234L
12456*
12456L
12appolo**
12appoloLL
Best Regards,
Amit
--------------------------------------------------------------------------------
Disclaimer: This message and its attachments contain confidential information
and may also contain legally privileged information. This message is intended
solely for the named addressee. If you are not the addressee indicated in this
message (or authorized to receive for addressee), you may not copy or deliver
any part of this message or its attachments to anyone or use any part of this
message or its attachments. Rather, you should permanently delete this message
and its attachments (and all copies) from your system and kindly notify the
sender by reply e-mail. Any content of this message and its attachments that
does not relate to the official business of Meru Cab Company Pvt. Ltd. must be
taken not to have been sent or endorsed by any of them. Email communications
are not private and no warranty is made that e-mail communications are timely,
secure or free from computer virus or other defect.
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com
To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com
To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
