Apr 29 2021 03:51 PM
I have a large list of 1200 clients phone numbers in Excel and I need to convert them as follows.
602-457-0377 Current value.
16024570377 Desired new value needed with no formula in the value.
Thank you in advance!
Apr 29 2021 10:11 PM - edited Apr 29 2021 10:12 PM
@Prestige_Realty Say all your numbers with the hyphens are in column A. Enter how you want to see the first number directly next to it in column B. From your description it would be like a number 1 plus all numbers from A, skipping the hyphens.
Select the entire range of cells where you want to repeat the pattern.
Now press Ctrl-E (Flash fill):
Apr 30 2021 07:14 AM
@Riny_van_Eekelen Brilliant! This is exactly what I needed. Thank you so much! I was spending hours Googling it and watching youtube videos and now I can do my whole worksheet within a minute!
Apr 30 2021 07:32 AM
@Prestige_Realty Great. Glad I could help.