| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Add characters in front or behind a cell
thanks
Have a nice day. vcff "Joel" wrote: The best way is to use a fromula in column b to add the extra characters. You can then copy the changes back to the original column using Copy - Past Special Values to remove the formula. To add caharcter it is very simple ="abcd"&A1 to add abcd at the beginning of the data =A1&"abcd" to add characters at the end of the data "vcff" wrote: Hi All I have two worksheets with the following info. Column A1: A170 have wordings of different length for both worksheets. I will like to add 4 extra characters in front for one worksheet and the opposite for the other worksheet (behind) in each cell. Thanks vcff |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to remove space at front and end of a cell | Excel Discussion (Misc queries) | |||
| Replacing last 3 characters and adding them to front | Excel Discussion (Misc queries) | |||
| How do I keep 2 zero's in front of s/n in a cell | Excel Discussion (Misc queries) | |||
| how to add a letter in front of each number in a cell | Excel Discussion (Misc queries) | |||
| how can i get a cell to hold a zero in front of a digit ie. 01 or. | Excel Discussion (Misc queries) | |||
Threaded Mode
