modify the formula to replace or substitute

Rubber Beaked Woodpecker

Board Regular
Joined
Aug 30, 2015
Messages
205
Office Version
  1. 2021
A1 I have the following formula;

=RIGHT(I6,5)

How could I modify the formula to replace or substitute and text that contains ":"

Many thanks

RBW
 

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.
Use the REPLACE or SUBSTITUTE functions on it?
There is no problem wrapping functions inside of other functions in Excel.

Why don't you show us an example of exactly what it is you are trying to accomplish.
 
Upvote 0
Ok found the answer.

 
Upvote 0
Solution
That link show you how to do exactly what I said (wrapping the function inside of another function).
There is tons of good documentation out there on all the functions which can be found with a simple Google search.
The thing to remember is that the "input" part of ANY function does NOT need to be a hard-coded value - you can substitute any formula that returns a value in its place.

Also, please try to be more detailed in your questions. Remember, while you may be familiar with the data and exactly what you are trying to accomplish, we are not. We only know what you tell us. Often times, showing us a simple example of exactly what it is you are trying to accomplish clarifies it much better than anything else.
 
Upvote 0

Forum statistics

Threads
1,224,828
Messages
6,181,204
Members
453,022
Latest member
RobertV1609

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top