Just need some help I have values in column CDE2-CDE130 thats in this format 2,9,8 and 4,5,7 and 2,0 ...I would like it to converted to 298 and 457 and 20 It must only delete the commas out......Easy one rep given for your help..Thank you
Just need some help I have values in column CDE2-CDE130 thats in this format 2,9,8 and 4,5,7 and 2,0 ...I would like it to converted to 298 and 457 and 20 It must only delete the commas out......Easy one rep given for your help..Thank you
Last edited by ricklou; 02-06-2017 at 05:31 AM.
try this.
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Try this
and copy down=SUBSTITUTE(CDE2,",","")
Teach me Excel VBA
Please Login or Register to view this content.
Uploading sheet.......very weird ran macros and its not giving an error and its not doing anything.Thank you Bakerman Imran Jindon
Last edited by ricklou; 02-06-2017 at 06:31 AM.
Attached the sheet .........
Select the cells
CRTL+H
Find what box, type (,) comma
Replace with box, type nothing
Click replace all.
Then
repeat the process (With out closing the menu)
Find what box, type space
Replace with box, type nothing
Click replace all.
Last edited by AB33; 02-06-2017 at 07:00 AM.
Ah,, I din't see this thread was updated... forum problem...
Please Login or Register to view this content.
You are welcome and thanks for the rep.
It was an easy one indeed.Convert array to numbers delete commas (Easy one )
You're welcome and thanks for rep+.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks