Hello all,
How to delete cells staring with symbols using VBA? Excel needs to recognize cells content starting with symbols and delete it from huge bunch of data.
Below I have given examples on how it looks like
&l1O(8U(s0P(s12H(s0S &k9.55H&a1L&l5.25C&l3E
------------ ------------------ ------------------ -------------------- --- ------------ ------ ------------- ----------------------
What does the valid data look like?
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Try
Please Login or Register to view this content.
Valid data starts with letters
It works. But it didn't delete below dashes. Any suggestion to delete row of below dashes
------------ ------------------ ------------------ -------------------- --- ------------ ------ ------------- ----------------------
You have to let us know which characters. In the first post you only mentioned one.
How many and which ones do you need deleting?
------------ ------------------ ------------------ -------------------- --- ------------ ------ ------------- ----------------------
I need to delete row of dashes
Try this:
Please Login or Register to view this content.
Last edited by xladept; 01-24-2019 at 02:50 PM.
Or as in post #3 with another character added.
Also deletes negative numerical values like -12345.
Please Login or Register to view this content.
Last edited by jolivanes; 01-24-2019 at 03:20 PM.
No It's deleting whole content. Let me explain clearly what i want to do
I want to delete cell con
&l1O(8U(s0P(s12H(s0S &k9.55H&a1L&l5.25C&l3E
?&l1O(8U(s0P(s12H(s0S &k9.55H&a1L&l5.25C&l3E - This has box with question mark at starting which I couldn't able to paste in here
What to delete row containting below dashes
------------ ------------ ------------ ---- -------------- --- ---------- ------------------------ -------- ---------- -------------
Want excel to find all cells which has PO Number and put a selection with current region and to do Text to columns delimited with respect to spaces
I need to some support using macros since it is imported from Text file which is causing this kinds of issue
2019-01-25 01-20-17 - Excel.png2019-01-25 01-21-22 - Excel.png
Re: My post #6
Just noticed now that the bottom of your first post is characters meant to be deleted. Not, as I initially thought, a way to spruce up your post.
My apologies.
Attach a Workbook which has all the data in it that needs deleting/changing.
Mark, color the cells maybe, which cells or rows need clearing contents or deleting.
A before and after sheet might work the best.
Now try this:
Please Login or Register to view this content.
@ xladept,
Here you provide Code as a solution while you are using Tippex.
Hi buddy.
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
Hi, initial code which you sent has cleared contents of &l1O(8U(s0P(s12H(s0S &k9.55H&a1L&l5.25C&l3E which i intented.
But it left out below code mentioned in pic as well. Can you modify same code to clear contents of below please
?&l1O(8U(s0P(s12H(s0S &k9.55H&a1L&l5.25C&l3E - This has box with question mark at starting which I couldn't able to paste in here
Its not working
2019-01-25 19-45-16_.xlsm - Excel.png2019-01-25 19-45-56_.xlsm - Excel.png
This unicode is very tricky.
Perhab only text and number not simbol
Please Login or Register to view this content.
"Presh Star Who has help you *For Add Reputation!! And mark case as Solve"
If t1= "" then t1= t else t1=t1&t
above line causing syntax error
2019-01-25 21-25-19_Microsoft Visual Basic for Applications - UKLC.xlsm [break] - [Module1 (Code.png
this causing error as well
this code not allow if character is simbol then clearContents,change is needed
if you allow only little simbol then change thisPlease Login or Register to view this content.
Please Login or Register to view this content.
Last edited by daboho; 01-25-2019 at 12:25 PM.
No It deleted whole dataset
can you give picture data will be to delete or not to delete
if you keep litte simbol you can modifay
Please Login or Register to view this content.
I want to delete cell if it's starts with symbols. Can you use conditions in VBA?
IF only first character is simbol (not text or number)
Please Login or Register to view this content.
Hi, it should delete only first character is symbol
&l1O(8U(s0P(s12H(s0S &k9.55H&a1L&l5.25C&l3E
It has deleted all cells which as symbols like Delivery:
Need slight modification to delete cell only if first character is symbol
Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
![2019-01-25 21-25-19_Microsoft Visual Basic for Applications - UKLC.xlsm [break] - [Module1 (Code.png](https://www.excelforum.com/attachments/excel-programming-vba-macros/608161d1548431757-how-to-delete-cells-and-rows-with-specific-characters-using-vba-2019-01-25-21-25-19_microsoft-visual-basic-for-applications-uklc.xlsm-break-module1-code.png){kind=link}
Bookmarks