Search results for query: *

Geoff Thanks so much for your help and patience. The problems are almost solved. R

I am in luck because there does not appear to be any numeric values within the other cells of the column as the house numbers are all within other cells. Does this make it possible?

Basically I downloaded from our webserver the details of our members. However, I had a problem in that the complete address was contained within a single cell. When I finally managed to delimit the address by the carriage return, it caused a problem; some address were shorter than others and...

The data is structured as follows, column b is where I want the postcodes moved to and thus is blank, column a is the source. I want to pick out the postcodes and move them into the next column col a | col b 1| london | 2| coventry| 3| PE34 3DA| 4| leeds | 5| CV3 3RD | I hope this...

I have a spreadsheet where a column cell contains a variation of values i.e. Town, County and Postcode. I want to find some way of identifing the Postcodes and copying them accross within the same row as they were sourced, to a specific column for Postcodes. Any help greatfully received. R

Thanks for the really prompt replies! The problem is now sorted out. Many thanks, Richard

Is there anyway to return Excel cells to the default blank state? I have a spreadsheet which has been given to me and should only be a few KB in size, however it totals several MB. All rows from 5000 onwards appear to have contained values within them at some point but are now empty, yet Excel...