Link to home
Create AccountLog in
Avatar of jonathanduane2010
jonathanduane2010

asked on

removing data from Excel file

Hi guys,

I was wondering how do i remove the brackets and everything in the brackets from attached excel file?

or if it can be done?
test.xlsx
Avatar of Joe Howard
Joe Howard
Flag of United States of America image

Search for [*] and replace with nothing.
ASKER CERTIFIED SOLUTION
Avatar of Joe Howard
Joe Howard
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of jonathanduane2010
jonathanduane2010

ASKER

when i try the find and replace it comes back with a weird formatting, i would love to just take the phone numbers?
Change the format of the column to number.
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
@pkwan, once the value have been turned into numbers, no formatting will turn them into text. Text is a data type. A number is a data type. You cannot change a data type by formatting.
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
ok i think i have done most of that, its now adding .00 to the end can i remove all of them? without deleting other 0 that might appear?
found it!!
Hi Guys, it wont preserve the number when i save it as a CSV ?
The format is preserved in the csv file (open it in notepad and see for yourself). When opening in Excel it uses the default format (General) unless you explicitly give it a different format (number).
ah ok, so we are using this as a batch sms it should be ok??
As long as the file is not being open by Excel you're good to go.