LinkBack URL
About LinkBacks
Column A Column B
Postcode: XXXX =REPLACE(A1,1,FIND(": ",A1),"")
In column B I am showing the XXXX, but when there is no data it it coming up with #VALUE!
Is there anyway of not having the #Value! and having the box empty?
Thanks
Column A Column B
Postcode: XXXX =REPLACE(A1,1,FIND(": ",A1),"")
In column B I am showing the XXXX, but when there is no data it it coming up with #VALUE!
Is there anyway of not having the #Value! and having the box empty?
Thanks
Hi
Use IFERROR.
=IFERROR(REPLACE(A1,1,FIND(":",A1),""),"")
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Try this -
Formula:
=if(A1="","",REPLACE(A1,1,FIND(": ",A1),"")
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Thanks for help and quick response - it works great. x
You are welcome.
Thanks for the feed back and also for the reb*
Pls, note that also arlu 1201,formula, works OK(with one more parenthesis at the end)
=if(A1="","",REPLACE(A1,1,FIND(": ",A1),""))
Oops yeah, thanks Fotis.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks