Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have a spreadsheet with descriptions that are well over the 255 character
limit for a cell. I need to move that data to another sheet and add characters to the beginning and end of the string. The formula that I use is =concatenate("!!<",CellDataFromOriginalSheet,"!!) that formula works for all cells in the original sheet with the exception of those that are longer than 255 characters. It truncates those that are longer. If I do a simple range copy from the original sheet to the new sheet then all of the cell contents are copied over and it will not truncate. How can I add the beginning !!< and ending !! characters to the entire content of the sheet? Now before you tell me to edit each line seperately please be advised that there are 3,046 lines of description that need to be copied to the new sheet. I was going to try a find and replace but there isn't any one character that I can search on at the beginning. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Create an if-then formula in Excel to limit column total? | Excel Discussion (Misc queries) | |||
Defined range problem | Excel Discussion (Misc queries) | |||
IF Function Help due to 7 limit | Excel Worksheet Functions | |||
Limiting characters in a cell | Excel Worksheet Functions | |||
How can i work a formula for time limit? | Excel Worksheet Functions |