Hi all
If I have "GREAT BRITAIN(GB)" in a cell and want to convert it to "Great Britain" is there a formula or function to do so?
Cheers
Hammer
Hi all
If I have "GREAT BRITAIN(GB)" in a cell and want to convert it to "Great Britain" is there a formula or function to do so?
Cheers
Hammer
Hi
Formula:Please Login or Register to view this content.
☚ Click ★ just below left if it helps, Boo?ath?
Hi, ref the attachment
Lovely!
Thank you very much once again kind person
Hi, Thanks for the kind feedback and rep
Here is a macro that you could employ. Highlight the cell(s) you wish to change and run the macro. Note that you can change the case to the one you wish to use by commenting out the two you don't want and uncommenting the one you want to keep.
Please Login or Register to view this content.
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
Many thanks for that too alansidman
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks