Thank you for showing this formula. However, I seem to also remove the space of each word. Is there any way that I can keep the space and can I keep URL in the file too? Thank you in advance
If you want to have a space in between words or any other char extracted (like . , - ) you can add them in new quotations in the brackets. {"A".."z","0".."9"," ","-","."}
I have an export from a SP list, there are a few columns that will contain Firstname.Lastname;# and 4 random numbers all in 1 cell, or there maybe three or four names in the cell, but they all follow that format. I am searching for a way to clean the cell so only Firstname.Lastname (or Firstname.Lastname for each person). Any advice or tips would be appreciated. (side note, I don't control this particular sharepoint list, so I can't modify the view or data and I can't install any plugins or additional apps to support this functionality)
Do you have a video that keeps the special characters? I'm trying to download a .csv that has commas, apostrophe, Ampersand, single quotations etc.., which I need but when it saves it as gibberish. Is there anything I can do to keep these as I need them?
Hello sir , I have doubt regarding mapping a cell data without the symbol or special character . For example I have in cell a1 14.5 % but I want to map only 14.5 to cell b1 ( = a1 but without symbol ) . How can I do this ? Please let me know in simple way . Thank you in advance .
It's not working and showing as "The name 'Text.Select' wasn't recognized. Make sure it's spelled correctly." but I entered the formula correctly. Could you please help me?
Hi, I know this was posted a year ago but I literally just had the same problem. For some super strange reason it was not coming up for me either... BUT when i typed Text with a capital T it finally came up.. makes no sense at all I thought I was going crazy
Thanks a lot, there were 11000 product titles to remove the numbers entered in the title, and I solved my case with one click.
Thank you for showing this formula. However, I seem to also remove the space of each word. Is there any way that I can keep the space and can I keep URL in the file too? Thank you in advance
Very helpful and easy to understand - thank you, Sir 👍
Super formula with Text.Select. Great video! Thank you very much.
Thank you so much Chester. Your video saved a life!
You are a super-genius!!! Super thanks. It was month that I was trying to remove them;)
If you want to have a space in between words or any other char extracted (like . , - ) you can add them in new quotations in the brackets. {"A".."z","0".."9"," ","-","."}
Thank you
Thankyou Chester. This does exactly what we have been looking for . Awesome :)
Boom! You are a lifesaver.
Wow this is Amazing! Thanks!
Thanks its very helpful
Thank you it was helpful 😊👍🏻
Thank you so much. Is easier than VBA
Perfect 💝
Very helpful thanks!
Helpful Info 😄
I have an export from a SP list, there are a few columns that will contain Firstname.Lastname;# and 4 random numbers all in 1 cell, or there maybe three or four names in the cell, but they all follow that format. I am searching for a way to clean the cell so only Firstname.Lastname (or Firstname.Lastname for each person). Any advice or tips would be appreciated. (side note, I don't control this particular sharepoint list, so I can't modify the view or data and I can't install any plugins or additional apps to support this functionality)
Thank you very much.
Thank you
Do you have a video that keeps the special characters? I'm trying to download a .csv that has commas, apostrophe, Ampersand, single quotations etc.., which I need but when it saves it as gibberish. Is there anything I can do to keep these as I need them?
What would the formula be if the value isn't a single-character string, but its a whole sentence?
But I need to show the space bar in between the name character. How can I do that?
can I do this with apostrophes. I am trying to remove unwanted apostrophes at the beggining and the end of my number for a column of cells
Hello sir , I have doubt regarding mapping a cell data without the symbol or special character . For example I have in cell a1 14.5 % but I want to map only 14.5 to cell b1 ( = a1 but without symbol ) . How can I do this ? Please let me know in simple way . Thank you in advance .
It's not working and showing as "The name 'Text.Select' wasn't recognized. Make sure it's spelled correctly." but I entered the formula correctly. Could you please help me?
You might have an older version of excel. This should work in 365.
Hi, I know this was posted a year ago but I literally just had the same problem. For some super strange reason it was not coming up for me either... BUT when i typed Text with a capital T it finally came up.. makes no sense at all I thought I was going crazy
This does not help with characters with accents.