Dear experts
looking help vb code to split out the value in column A how do i split all base on "," to an separate row ?
example contents in the vol A:
APPLE,RINGER,FRANKIE
Thanks very much
Dear experts
looking help vb code to split out the value in column A how do i split all base on "," to an separate row ?
example contents in the vol A:
APPLE,RINGER,FRANKIE
Thanks very much
In A1 Cell
APPLE,RINGER,FRANKIE
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
Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. 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 demonstrated, mock them up manually if needed. Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
Dear Sixthsense
file attached
Please show your example in english letters with the expected result in another sheet
Dear Sixthsense
New file attached
Try this...
Please Login or Register to view this content.
Dear Sixthsense
it amazing what i wanna do ..
thanks very much.
Dear Sixthsense
sorry, disturb again which i find that if the not the multiple product in cells ( that mean without "," ) caused a error !!
may i have you help again
Just a less-bulletproof code..
Please Login or Register to view this content.
Regards!
=DEC2HEX(3563)
If you like someone's answer, click the star to give them a reputation point for that answer...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks