LinkBack URL
About LinkBacks
Screenshot 2018-12-15 14.22.38.png
Screenshot_9.jpg
Macro :
Please Login or Register to view this content.
Hi Team,
I want to format text as in second image. I dont know much about vba. Can you please advise.
Thanks,
Gajjo
Screenshot 2018-12-15 14.22.38.png
Screenshot_9.jpg
Macro :
Please Login or Register to view this content.
Hi Team,
I want to format text as in second image. I dont know much about vba. Can you please advise.
Thanks,
Gajjo
Last edited by Gajjo_Boss; 12-15-2018 at 05:33 AM. Reason: add attach
Welcome to the forum!
Two things:
1. You posted in the wrong section - I have moved the thread for you.
2. You did not use code tags (see our forum rules) - I have added them for you this time.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Thank you very much. I wii go throught forum rules.
am unable to attach file. Can you please advise for above.
Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.
I cannot help you with the VBA - somebody else will.
thank you. ihave attach file now.
Please check row 5 in your Desired Output image.
Is the correct result as shown, or should it be
Tip tinner. used to clean the tip of 'The Soldering Iron'
If the image is correct then you will need to explain the rules of your logic better as it doesn't appear to match the other rows.
thats mistake. I want it as 'The Soldering Iron'
Last edited by Gajjo_Boss; 12-15-2018 at 05:54 AM.
Anyone? I just need text in single quotes in proper case.
Do you need it in red as well, or did you just do that to highlight what should be changed?
I think you're going to struggle to get it to work using single quotes. In most cases it can be made to work, but anything like this will be a problem
solder wick': the wick soaks up molten solder, it’s useful to clean the excess of solder.
Will result in
solder wick': The Wick Soaks Up Molten Solder, It's useful to clean the excess of solder.
i did just to highlight. i dont want anycolour. just proper case for text witin single quote.
What if instead of going by the apostrophes you look for the colon? Maybe something like this =PROPER(LEFT(A1,FIND(":",A1)))
Because list i get has text in single quote eg 'Text Sample' and which should be in proper case.
can you tell me solution u have.
As far as I can see, this is giving the correct results with the sample provided.
Single quotes are not the best thing to use for this, if you check your sample, you will see that every entry in column A has a hidden single quote at the beginning as a text qualifier. To get around this I've had to count the number of single quotes in each cell to determine if there should be one at the start or not. While it works with the sample, it could prove to be unreliable with other data.Please Login or Register to view this content.
yes, that hidden ' issue. I have created macro which make it to visiable . I select them and run below macro
Im testing your macro.Please Login or Register to view this content.
Thank you very much.
Last edited by Gajjo_Boss; 12-17-2018 at 03:37 PM.
Thank you very much again. Code work perfectly.
Thank you for help.
what if i need to update changes in same cell.
This code work exactly as i wanted but i need value to be updated in same cell.
and this code not making first word of sentence capital if it is in small case.
Last edited by Gajjo_Boss; 12-16-2018 at 02:52 PM.
is this ok to use below code if i need value to be updated in same cell.
Please Login or Register to view this content.
Last edited by Gajjo_Boss; 12-17-2018 at 03:35 PM.
Thank You very much again.
Your post does not comply with Rule 2 of our Forum RULES. Use code tags around code.
Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.
Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here
(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 6)
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Try this (untested)
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks