| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I need to add 3 letters into each cell at the begn./Cell has #'s
I have a column of #'s, I need to add 3 letters in each cell before the #'s.
Is there a formula for this, so I wouldn't have to retype all the #'s? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I need to add 3 letters into each cell at the begn./Cell has #'s
You can use a formula like the following in another, blank, column:
="XYZ"&A1 where "XYZ" are the letter you want to prepend to the cell value. Copy this formula down as far as you need to go. If want to permanently change original value, you can copy the formula range and Paste Special, Value, from the Edit menu to paste the values on top of the original data. Then you can delete formula column. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (email address is on the web site) "Sharon R" wrote in message ... I have a column of #'s, I need to add 3 letters in each cell before the #'s. Is there a formula for this, so I wouldn't have to retype all the #'s? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I need to add 3 letters into each cell at the begn./Cell has #'s
Create a helper column with the following formula (assumes your numbers are
in column A): =CONCATENATE("xxx",A1) and fill down to the end of your range. Then copy the helper column, paste special, values, on column A, and delete the helper column. Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "Sharon R" wrote: I have a column of #'s, I need to add 3 letters in each cell before the #'s. Is there a formula for this, so I wouldn't have to retype all the #'s? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I need to add 3 letters into each cell at the begn./Cell has #
Worked Perfect!!! Thank You!!!!!
"Dave F" wrote: Create a helper column with the following formula (assumes your numbers are in column A): =CONCATENATE("xxx",A1) and fill down to the end of your range. Then copy the helper column, paste special, values, on column A, and delete the helper column. Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "Sharon R" wrote: I have a column of #'s, I need to add 3 letters in each cell before the #'s. Is there a formula for this, so I wouldn't have to retype all the #'s? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I need to add 3 letters into each cell at the begn./Cell has #
Perfect Thank You!!!!!
"Chip Pearson" wrote: You can use a formula like the following in another, blank, column: ="XYZ"&A1 where "XYZ" are the letter you want to prepend to the cell value. Copy this formula down as far as you need to go. If want to permanently change original value, you can copy the formula range and Paste Special, Value, from the Edit menu to paste the values on top of the original data. Then you can delete formula column. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (email address is on the web site) "Sharon R" wrote in message ... I have a column of #'s, I need to add 3 letters in each cell before the #'s. Is there a formula for this, so I wouldn't have to retype all the #'s? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extract letters from a cell | Excel Worksheet Functions | |||
| letters cut off in cell | Excel Worksheet Functions | |||
| Pull 1st 4 letters from another cell | New Users to Excel | |||
| Copy the first two or three letters of a cell to another one | Excel Discussion (Misc queries) | |||
| Select only the letters from a cell | Excel Discussion (Misc queries) | |||
Linear Mode
