I have column with lot of reference no, the issue it is very bulky to read .
looking a code to change colour of reference from red to blue after each comma
HM8143,HM8144,HM8142,HM8664,HM8141,HM8150,HM8404,HM4481,HM8794,HM8445,HM8446,HM8656
I have column with lot of reference no, the issue it is very bulky to read .
looking a code to change colour of reference from red to blue after each comma
HM8143,HM8144,HM8142,HM8664,HM8141,HM8150,HM8404,HM4481,HM8794,HM8445,HM8446,HM8656
Hi Jean,
Instead of coloring, how about making a big table out of all those text? See sheet2 where I've done this for you. Took about a minute. Will this help in solving your problem?
PQ Make Table from Comma Delimited.xlsx
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Hi Marvin
Thanks for response but indeed, the data is more complex as there are other columns so I cannot apply as in sheet 2.
You could try thisBut it is slowPlease Login or Register to view this content.
@ Fluff13,
Typical Fluff stuff!But it is slow...
Considering the massive changes the Code has to handle, I would object to your comment that "it is slow".
Fantastic job!
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] .
Hello Fluff
Despite it is slow, the job is done .
Thank you for assistance
Glad to help & thanks for the feedback.
@Winon
Would you prefer it if I said, "This will take sometime to complete"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks