Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I add text to a column of numbers
I have a column if invoice numbers 6234,6235 etc and I need to add "SCHERS"
to each one. How do I do that w/o having to recopy the whole column |
#2
|
|||
|
|||
If 6234 were in A1, in B1 try
=A1&"SCHERS" Drag that down to the end of the range then Copy Paste Special Values the new range to lose the formulas. You can then cut and paste it back to the original location if necessary. Note that this column will now be all text values and calculations will probably not work, Regards, Alan. "Kelli" wrote in message ... I have a column if invoice numbers 6234,6235 etc and I need to add "SCHERS" to each one. How do I do that w/o having to recopy the whole column |
#3
|
|||
|
|||
Insert a new column B and use a formula like:
=a1&"SCHERS" and drag down. Then edit|copy those cells and select the original range and edit|paste special|values (and delete the helper column.) Kelli wrote: I have a column if invoice numbers 6234,6235 etc and I need to add "SCHERS" to each one. How do I do that w/o having to recopy the whole column -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting numbers and text separately | Excel Discussion (Misc queries) | |||
Consecutive Numbers down a column not to Exceed 49 | Excel Worksheet Functions | |||
How to sum top 5 numbers from the column of numbers | Excel Discussion (Misc queries) | |||
need to find which numbers (3+) in a column sum to a value | Excel Discussion (Misc queries) | |||
How to Replace numbers and text with numbers only? | Excel Worksheet Functions |