LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
EaglesNest
 
Posts: n/a
Default Cell 255 character limit and formula

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Create an if-then formula in Excel to limit column total? Nancy M Excel Discussion (Misc queries) 2 February 13th 05 10:47 PM
Defined range problem Pat Excel Discussion (Misc queries) 8 January 17th 05 11:25 AM
IF Function Help due to 7 limit John F Excel Worksheet Functions 11 January 12th 05 10:07 PM
Limiting characters in a cell Colin Hayes Excel Worksheet Functions 7 December 30th 04 03:20 PM
How can i work a formula for time limit? Roze Excel Worksheet Functions 2 November 25th 04 02:41 PM


All times are GMT +1. The time now is 08:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"