Hi everyone..
I really need a help..on how to delete comma in text in one column. example address records :
AR FACTOR RESOURCES SDN BHD,2-6-1, 6TH FLOOR, BLOCK D, DIAMOND SQUARE.
please help me..urgent..tqvm
Hi everyone..
I really need a help..on how to delete comma in text in one column. example address records :
AR FACTOR RESOURCES SDN BHD,2-6-1, 6TH FLOOR, BLOCK D, DIAMOND SQUARE.
please help me..urgent..tqvm
hi
maybe this
Please Login or Register to view this content.
Regards, John55
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
...enjoy -funny parrots-
Just do a find replace. Select the whole column. Press Ctrl+F, Find "," and replace with nothing. (Do not select/type anything in the replace box).
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 so much arlu201..why i didn't think this way..maybe my brain was jammed just now..hehehe..u really help me..
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks