LinkBack URL
About LinkBacks
I need to know the way to substitute multiple times. Right now I'm running the equation, "=SUBSTITUTE(Sheet1!A$1,"blue",Sheet1!B1)". I need to substitute 3 charters from Sheet1a1 instead of just "blue".
multiple substitutions
I need to know the way to substitute multiple times. Right now I'm running the equation, "=SUBSTITUTE(Sheet1!A$1,"blue",Sheet1!B1)". I need to substitute 3 charters from Sheet1a1 instead of just "blue".
Which three characters? Is it always characters 4, 5 and 6, for example? Please post a sample with contents of cell A1, before and after, and B1. If there are any variations, then tell us now rather than later.
A sample workbook is often useful.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
You can amend something like this to your needs:
Please Login or Register to view this content.
Please consider:
Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks