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,184
    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"

Some videos you may like

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
  •