modify the formula to replace or substitute

[Rubber Beaked Woodpecker]

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

 

[Joe4]

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.

 

[Rubber Beaked Woodpecker]

Use the REPLACE or SUBSTITUTE functions on it?

Why don't you show us an example of exactly what it is you are trying to accomplish.

This I cannot fathom hence the question.

 

[Rubber Beaked Woodpecker]

Ok found the answer.

Can the Right and Substitute Formulas be combine in to one Formula

Hi Forum, I use the following formula to extract the information I need. In cell B1 I use = Right(A1,30) then In cell C1 I use = Substitute(B1,"","") I was wondering if there is a way that I combine both the Right and Substitute function into just one cell. Thanks

www.mrexcel.com

 

[Joe4]

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.