LinkBack URL
About LinkBacks
hi
i have phone numbers separated by commas in single cell i want to convert it into single column.
need macro script to do this automatically
i want phone numbers without country code.
refer my sample sheet for data to be converted.
thank you
hi
i have phone numbers separated by commas in single cell i want to convert it into single column.
need macro script to do this automatically
i want phone numbers without country code.
refer my sample sheet for data to be converted.
thank you
Administrative Note:
Welcome to the forum.
Is your forum profile showing the Excel PRODUCT that you need this to work for?
Members will tailor the solutions they offer to the Office PRODUCT (Excel, NOT Windows) that you have. Please check that your forum profile is up-to-date in this respect. If you aren't sure, in Excel go to File | Account and report what it says below the MS logo at the top of that page. If your product is for Mac, please also state this.
The three most recent Excel products are Excel 2019, Excel 2021 and MS365 - if you are using MS365, please give this name along with the version number in your profile (e.g. MS365 Version 2306). This is in the About Excel section further down the Account page.
Thanks.
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.
There are no expected results in your workbook. Please add these manually for the example string provided.
If you have O365 then a formula
Formula:
Please Login or Register to view this content.
Or with code
Please Login or Register to view this content.
thank you..i will do it
thank you for the code..can i get sample excel book ..am new to this
UDF
Use in cell like
=TRANSPOSE(GetPhoneNum(A1))
Please Login or Register to view this content.
thank you sir ..
Hi
following error occurs when i use this formula
kindly help
PFA
1) You have 2 modules with same function
Reomve "Module2"
Select Module2 - Right Click - Remove Module2 - Click "No" to Export option.
2) Delete Current code in Module1 and paste following (much faster)
Please Login or Register to view this content.
Last edited by jindon; 05-04-2024 at 07:08 AM. Reason: File Attached.
Please Login or Register to view this content.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Please Login or Register to view this content.
Last edited by daboho; 05-04-2024 at 01:02 PM.
"Presh Star Who has help you *For Add Reputation!! And mark case as Solve"
thank you sir
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks