Text.

Nigel Martin · Apr 8th, 2002, 04:34 AM

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 · Apr 8th, 2002, 04:47 PM

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 · Apr 8th, 2002, 05:09 PM

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

Apr 8th, 2002, 04:47 PM	#2
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	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 ::

Apr 8th, 2002, 05:09 PM	#3
Jack in the UK Join Date: Feb 2002 Posts: 3,063	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"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 8th, 2002, 04:34 AM	#1
Nigel Martin Join Date: Feb 2002 Posts: 133	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 ?