Hi.
The idea is as follows. I have a column with values and text
1
delete
delete
3
4
delete
6
delete
3
and what I wanted is to have a formula to give me back only the numbers but no spaces between them.
in the next column should appear as follows
1
3
4
6
3
If I tried but I just appeared in the middle spaces and spaces can not appear ... There are way to solve this?
thank you
Last edited by marreco; 11-21-2012 at 09:13 AM.
"No xadrez nem sempre a menor dist?ncia entre dois pontos ? uma linha reta" G. Kasparov.
If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select b from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.
If you data is in A column try this:
Formula:
Please Login or Register to view this content.
and comfirm with ctrl+shift+enter (not just enter)
Or this to avoid error:
Starting from B2:
Formula:Please Login or Register to view this content.
again CSE
Last edited by zbor; 12-04-2012 at 05:01 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks