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
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