Dear Expert,
i want to remove the semicolon from the end (right side) of the cell and left all values unchanged (as per the attachment)
i have tried but unable to find desired result.
plz assist.
Thanks in advance.
Dear Expert,
i want to remove the semicolon from the end (right side) of the cell and left all values unchanged (as per the attachment)
i have tried but unable to find desired result.
plz assist.
Thanks in advance.
- Do a find & replace with the find field set to look for double semicolons ( ;; ) and the replace field left blank.
- Put the following formula in cell C2 and copy down:
Formula:Please Login or Register to view this content.
- Paste Special values as desired
Don't just use the answers provided for you. Try to understand how it works by reverse engineering or asking about it.
Please mark the thread as [SOLVED] (Thread Tools->Mark thread as Solved) when answered.
If you're happy with an answer given, please click the * under the person's name to boost their reputation.
Got ur point Craig
Thanks alot !!!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks