Hi friends, I want to replace the dash sign to blank while concatenate. If I enter dash sign either in column 'c, d, e, or f' then the dash sign should be replace with blank '""' in output in column 'g'.
Now I'm getting syntax error. please suggest me a correction.
Code is:
Thanking you in anticipation.
Please Login or Register to view this content.
Mukesh
Try this...
Please Login or Register to view this content.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Hi, Mukesh,
if you check the row to be greater or equal to 7 in order to proceed with the code there is no need to check again later if it will be greater 1 - this must be fulfilled. Maybe try
This should work fine if you are only handling one row at a time.Please Login or Register to view this content.
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Hello Holger,
Excellent! It's working fine.
Thank you for solving my problem.
I want to use this code in my another file where the concatenate sequence is little different as follows:
Title 'C First name 'E Surname 'D columns. Please tell me how to change it.
Thank you once again for your guidance.
Mukesh
Hi Sixthsense ,
Excellent! It's working fine.
Thank you for solving problem.
Mukesh
Hi Sixthsense ,
Excellent! It's working fine.
Thank you for solving problem.
Mukesh
Hi, Mukesh,
like this:
Ciao,Please Login or Register to view this content.
Holger
Hi Holger,
Excellent! Thank you.
Mukesh
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks