Text.

[Nigel Martin]

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 ?

 

[Chris Davison]

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

 

[Jack in the UK]

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..