Hello,
I'm trying to convert the results of a vlookup from 828xxxxx, 828zzzzz etc to just xxxxx, zzzzz etc. So, I just want to take the 828 out. I have tried combining the substitute function with the vlookup but I can't get it to work.
=VLOOKUP($B13,'ESR - Dowload'!$A:$W,20,FALSE)
The above lookup brings in the information e.g 828xxxx
=SUBSTITUTE(N13, 828, " ")
If I copy the values into another column and then use the above formula I will get an output e.g xxxx
How can I combine the above formula into one? I have tried numerous ways but just get error messages.
Any idea?
Bookmarks