Text.
Text.
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Text.

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Posts
    133
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I ahve a spreadsheet with columns containing names and addresses etc. with the last column containing a large amount of text. This text can be upward of 1000 characters i know it can be spread over various columns but that does not seem very proffesional to me. Any ideas. Or is a job for Access with its memo field facility ?

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Nigel,

    no replies, so I'll stick my oar in....

    is this 1000+ characters text column some sort of memorandum field ? like, comments from various staff over the weeks etc ?

    ie it's not integral to the actual name and address data....

    what exactly do you want to do with it ? is it a pain ?

    I have somethign similar where I track the progress of outstanding bank rec items (who they were referred to, what action was agreed to etc etc which makes an unweildly column sometimes). So I chuck it onto it's own sheet as a VLOOKUP table..... accessed by VLOOKUP-ing a concatenation of unique data : in your case : name & address & zip code, maybe

    Hope this gives you somethign to think about, if nothing else


    :: Pharma Z - Family drugstore ::

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,169
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Hi guys nice call chris im a pain for eas of read so i add chr(13) between and additions or joinong od data from more that one cell of sorce. Not forgettinmg to addf & all over the place.

    Copy paste as value and .. done..


    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com