zachvaldez
asked on
remove space
My column for phone field display the phone list with extra space ....
(999) 999-9999.
I'd like to remove the space after the")" so to show as
(999)999-9999 .What is the column formula to edit the list?
Thanks
(999) 999-9999.
I'd like to remove the space after the")" so to show as
(999)999-9999 .What is the column formula to edit the list?
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks,
while going down the list, I saw phone formats as "999-999-9999"
How will I transform it to "(999)999-9999" format so it is the same all throughout?
while going down the list, I saw phone formats as "999-999-9999"
How will I transform it to "(999)999-9999" format so it is the same all throughout?
zachvaldez,
It would be useful to see some sample data and/or a sample file. EE now allows you to directly upload files to your question.
The sample file should clearly illustrate both the input and the expected output given that input. The sample file need not be very large, but it should have enough examples to cover the expected range of values/scenarios.
Please be advised that once you upload a file, it can be publicly accessed, and that it may not be possible to fully and permanently delete it. The file may also be indexed by the major search engines.
Therefore, be very careful about posting proprietary, confidential, or other sensitive information. If necessary, use "fake" and/or obfuscated data in your sample.
Please note that at present EE restricts uploads to certain file types. If your file type does not match those in the list, you can use http://www.ee-stuff.com instead, which is not officially an EE site, but is run by people connected to EE.
Patrick
It would be useful to see some sample data and/or a sample file. EE now allows you to directly upload files to your question.
The sample file should clearly illustrate both the input and the expected output given that input. The sample file need not be very large, but it should have enough examples to cover the expected range of values/scenarios.
Please be advised that once you upload a file, it can be publicly accessed, and that it may not be possible to fully and permanently delete it. The file may also be indexed by the major search engines.
Therefore, be very careful about posting proprietary, confidential, or other sensitive information. If necessary, use "fake" and/or obfuscated data in your sample.
Please note that at present EE restricts uploads to certain file types. If your file type does not match those in the list, you can use http://www.ee-stuff.com instead, which is not officially an EE site, but is run by people connected to EE.
Patrick
ASKER
Im getting circular reference error when I do teh substitute function.
I point it to the cell and pasted the formula with the cell number(substitute "A2" with "N50") and I get the error
I point it to the cell and pasted the formula with the cell number(substitute "A2" with "N50") and I get the error
Did you put the formula in N50? That would cause a circular reference :)
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
sounds good to do sort of backup column. I'll try..
ASKER
If Id like to trnsform back (999)999-9999 to display as (999) 999-9999 (with a space), what is the formula?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
This seems to be meandering a bit. I think the original question has been answered :)
ASKER
I just want to see both sides of the formula to understand fully
=SUBSTITUTE(TRIM(A2),") ",")")