How do I prefix a character to all all the filled in cells in a column
A Andy Brown Aug 10, 2005 #2 Big Boss said: How do I prefix a character to all all the filled in cells in a column Click to expand... To do this with a formula, use e.g. =IF(A1<>"","X"&A1,"") in a spare column and drag it down. If you want to go on to replace the originals, copy the formulas, then use Edit -- Paste Special -- Values.
Big Boss said: How do I prefix a character to all all the filled in cells in a column Click to expand... To do this with a formula, use e.g. =IF(A1<>"","X"&A1,"") in a spare column and drag it down. If you want to go on to replace the originals, copy the formulas, then use Edit -- Paste Special -- Values.
B Big Boss Aug 10, 2005 #3 Thank you for responding to my query. I guess I was not clear. My apologies. I will rephraze my question. I have data (numbers and text) in 20 cells A1 to A20 and I want to add "-" in the front of contents of A1 to A20. How do I do it without using F2? Thanks Big Boss
Thank you for responding to my query. I guess I was not clear. My apologies. I will rephraze my question. I have data (numbers and text) in 20 cells A1 to A20 and I want to add "-" in the front of contents of A1 to A20. How do I do it without using F2? Thanks Big Boss
A Andy Brown Aug 10, 2005 #4 Big Boss said: I have data (numbers and text) in 20 cells A1 to A20 and I want to add "-" in the front of contents of A1 to A20. How do I do it without using F2? Click to expand... Select B1:B20, then type: ="-"& Then click on A1, then press CTRL+Enter. Refer to previous reply for how to convert these from formulas to actual values.
Big Boss said: I have data (numbers and text) in 20 cells A1 to A20 and I want to add "-" in the front of contents of A1 to A20. How do I do it without using F2? Click to expand... Select B1:B20, then type: ="-"& Then click on A1, then press CTRL+Enter. Refer to previous reply for how to convert these from formulas to actual values.
R Ron Rosenfeld Aug 11, 2005 #5 On Wed, 10 Aug 2005 01:29:04 -0700, "Big Boss" <Big How do I prefix a character to all all the filled in cells in a column Click to expand... Select the cells. Format/Number/Custom Type: -0;-0;-0;-@ --ron
On Wed, 10 Aug 2005 01:29:04 -0700, "Big Boss" <Big How do I prefix a character to all all the filled in cells in a column Click to expand... Select the cells. Format/Number/Custom Type: -0;-0;-0;-@ --ron