I have the following format EWR:...:ADD and would like to convert to EWRADD. Thus, without any periods, colons, etc. How do I do the conversion?
THANKS!
I have the following format EWR:...:ADD and would like to convert to EWRADD. Thus, without any periods, colons, etc. How do I do the conversion?
THANKS!
Use the Find and Replace Function found on the Ribbon.
https://www.dummies.com/software/mic...place-feature/
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
ExcelForum_Question_Formt.xlsx
I want to get rid of the periods and colons in the attached doc.
THANK YOU!
As per Alan's suggestion, it took me two find and replaces.
first, find what >> : replace with >> leave blank
make sure it isn't on exact match.
second, find what >> . replace with >> leave blank
got rid of all no matter how many were in a cell.
Only highlight column B for it to work otherwise it will remove those from column A too.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Now, if you want a formula this in another cell would work... =SUBSTITUTE(SUBSTITUTE(B2,":",""),".","")
then just drag down.
Thank you very much!
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks