What if I have a list of American numbers, Chinese numbers, Japanese numbers, etc. that all need their respective country codes fixed? Could you do another video demonstrating that?
Hi, I Want To Know if WE Can Print the Snake Column Into One Page For Example I Have Data For Employee Contact (400 Members) As S/N, Name, and Mobile Number. For In One Page 1 To 50 The Next To It 50 To 100 Then Next 101 To 150 In One Page Without Using Any Formula.
Hi. You could try using Flash Fill for this: th-cam.com/video/_8L1VAxTZNU/w-d-xo.html or th-cam.com/video/aMYg3q9kOZU/w-d-xo.html You could also try Find and Replace. You would repeat the Find & Replace for each type of character you want to remove (once for the open parentheses, the close parentheses, and the space) and don't type anything in the "Replace" box: th-cam.com/video/inbaKMwzWA8/w-d-xo.html Perhaps Text to Columns (although this might be a little more cumbersome). You could split the columns wherever there is a space or a parentheses, then use CONCAT or CONCATENATE to join only the portions you want. Text to Columns: th-cam.com/video/_1UmnKce-vs/w-d-xo.html CONCAT, CONCATENATE: th-cam.com/video/8wyGjqH8OTQ/w-d-xo.html Hope one of these works for you and thank you for stopping by!
This did not work for me. It didn't change a thing
Thank you. This is simple and straight forward
I’m so happy you liked this! Thanks 🙂
Thank you for your help! Super easy 😊
What if I have a list of American numbers, Chinese numbers, Japanese numbers, etc. that all need their respective country codes fixed? Could you do another video demonstrating that?
Thanks a lot . This video really helped me a lot. take Care
That’s great! I’m so glad this helped you. And you take care as well 🙂
What if I have to work with different country codes in the same spreadsheet?
Thank you! Very helpful!
Thanks so much. Glad it was helpful! 🙂
Hi, I Want To Know if WE Can Print the Snake Column Into One Page For Example I Have Data For Employee Contact (400 Members) As S/N, Name, and Mobile Number. For In One Page 1 To 50 The Next To It 50 To 100 Then Next 101 To 150 In One Page Without Using Any Formula.
Thanks this is really helpful 🎉
I’m so happy this tutorial helped you out! Thanks so much 🙂
Very useful .. Thank you
Thanks so much, Magdi! I’m happy this was useful for you 🙂
thanks! saved my life
That’s great, Rezuana! So happy this helped you 🙂
Thank you Y! What would you like to be called? Great Excel tip! Will save me a 🙂lot of time.
That’s excellent, Larry. I’m so happy this will help you save time 🙂 Thanks so much!
And people call me Yil (pronounced like “Jill”) 🙂
how do I do the reverse? Remove spaces and parenthesis?
Hi. You could try using Flash Fill for this: th-cam.com/video/_8L1VAxTZNU/w-d-xo.html or th-cam.com/video/aMYg3q9kOZU/w-d-xo.html
You could also try Find and Replace. You would repeat the Find & Replace for each type of character you want to remove (once for the open parentheses, the close parentheses, and the space) and don't type anything in the "Replace" box: th-cam.com/video/inbaKMwzWA8/w-d-xo.html
Perhaps Text to Columns (although this might be a little more cumbersome). You could split the columns wherever there is a space or a parentheses, then use CONCAT or CONCATENATE to join only the portions you want. Text to Columns: th-cam.com/video/_1UmnKce-vs/w-d-xo.html CONCAT, CONCATENATE: th-cam.com/video/8wyGjqH8OTQ/w-d-xo.html
Hope one of these works for you and thank you for stopping by!
Those options to select phone number do not appear
thanks it is very helpful
Thank you! I'm so glad you found this helpful 🙂
Thanks
Thank you! So happy you liked this 🙂