Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Prefix
How do I prefix a character to all all the filled in cells in a column
|
#2
|
|||
|
|||
|
#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 "Andy Brown" wrote: "Big Boss" <Big wrote in message ... How do I prefix a character to all all the filled in cells in a column 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. |
#4
|
|||
|
|||
"Big Boss" wrote in message
... 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? 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. |
#5
|
|||
|
|||
On Wed, 10 Aug 2005 01:29:04 -0700, "Big Boss" <Big
wrote: How do I prefix a character to all all the filled in cells in a column Select the cells. Format/Number/Custom Type: -0;-0;-0;-@ --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
adding the same prefix or suffix to a range of cells | Excel Discussion (Misc queries) | |||
how do i prefix a column with letters | Excel Discussion (Misc queries) | |||
Adding a prefix to a cell by using a formula | Excel Discussion (Misc queries) | |||
Cell value prefix | Excel Worksheet Functions | |||
How do I enter a prefix number to a colum of numbers | Excel Worksheet Functions |