The following sample narrative needs to be uploaded to our offsite storage facilty database, which needs a hard return at maximum 255 characters, but I would like the hard return at the beginning of each client matter number. So the cell will go from this:
4-2512 Wilbert Carl breuer, II v. Isiah Hemlock [*Correspondence, client's File, Atty notes 22-7270 Cheese Farm as Subrogee of King via v. Rudolph Hart [Billing, pleadings, corresp, discovery, client's File, original discovery, Atty notes 2025-7285 Dollar Bill v. Imc Pepper, Inc. [Corresp., Billing, pleadings, client's File 2060-5025 Hal v. Hall [Billing, Correspondence, pleadings, Atty notes, discovery 52-7327 Smith v. Sith [Discovery, Med Records Virginia, Med Records Matthew, Billing, Spe, cial damages.
to this (the hard returns can be symbols embedded in the cell that the upload will recognize so it formats the upload like this:
4-2512 Wilbert Carl breuer, II v. Isiah Hemlock [*Correspondence, client's File, Atty notes
22-7270 Cheese Farm as Subrogee of King via v. Rudolph Hart [Billing, pleadings, corresp, discovery, client's File, original discovery, Atty notes
2025-7285 Dollar Bill v. Imc Pepper, Inc. [Corresp., Billing, pleadings, client's File
2060-5025 Hal v. Hall [Billing, Correspondence, pleadings, Atty notes, discovery
52-7327 Smith v. Sith [Discovery, Med Records Virginia, Med Records Matthew, Billing, Spe, cial damages.
It may also be true that there is only one client matter number listed in a cell, but for which there is 750 characters in the cell, so the break needs to be at maximum 255 characters.
I'm exhausted trying to find this on the web. I have two thousand lines of narrative (all in column D) that I need to edit. Any help would be greatly appreciated.
Michael
4-2512 Wilbert Carl breuer, II v. Isiah Hemlock [*Correspondence, client's File, Atty notes 22-7270 Cheese Farm as Subrogee of King via v. Rudolph Hart [Billing, pleadings, corresp, discovery, client's File, original discovery, Atty notes 2025-7285 Dollar Bill v. Imc Pepper, Inc. [Corresp., Billing, pleadings, client's File 2060-5025 Hal v. Hall [Billing, Correspondence, pleadings, Atty notes, discovery 52-7327 Smith v. Sith [Discovery, Med Records Virginia, Med Records Matthew, Billing, Spe, cial damages.
to this (the hard returns can be symbols embedded in the cell that the upload will recognize so it formats the upload like this:
4-2512 Wilbert Carl breuer, II v. Isiah Hemlock [*Correspondence, client's File, Atty notes
22-7270 Cheese Farm as Subrogee of King via v. Rudolph Hart [Billing, pleadings, corresp, discovery, client's File, original discovery, Atty notes
2025-7285 Dollar Bill v. Imc Pepper, Inc. [Corresp., Billing, pleadings, client's File
2060-5025 Hal v. Hall [Billing, Correspondence, pleadings, Atty notes, discovery
52-7327 Smith v. Sith [Discovery, Med Records Virginia, Med Records Matthew, Billing, Spe, cial damages.
It may also be true that there is only one client matter number listed in a cell, but for which there is 750 characters in the cell, so the break needs to be at maximum 255 characters.
I'm exhausted trying to find this on the web. I have two thousand lines of narrative (all in column D) that I need to edit. Any help would be greatly appreciated.
Michael