EXCEL tabular data extract

S

Surt

Hi all!

Hi have a excel file with the next kind of data:

TÍTULO MINORISTA
NOMBRE XXXXXXXXX
CENT./SUC. RRRRRRRR
DIRECCIÓN TTTTTTTT
LOCALIDAD VVVVVVVVVVV
PROVINCIA SSSSSSSSSSS
C.P. 11111
TELÉFONO 4323543543654364
FAX 435435454543543543

TÍTULO MINORISTA
NOMBRE XXXXXXXXX
CENT./SUC. RRRRRRRR
DIRECCIÓN TTTTTTTT
LOCALIDAD VVVVVVVVVVV
PROVINCIA SSSSSSSSSSS
C.P. 11111
TELÉFONO 4323543543654364
FAX 435435454543543543



I want to extract all the faxes from that table, bu the problem is that all
is in rows, not in colums. Can I make a function or something to extract
only the faxes?

Forget my english please... :p
 
D

David McRitchie

If your data is that consistent you can use one of the
methods on http://www.mvps.org/dmcritchie/excel/snakecol.htm#wf

On a second worksheet extract information from your contacts worksheet,
A1: =OFFSET(contacts!$A$1,ROW()*10-11+COLUMN(),0)

then use the fill handle to copy fromula through column J
and down as far as you have data.

then you could copy, then paste special values,
and remove the string "FAX " from the 9th column (column i)
and other titles you don't want to see within your data,
then delete the columns you don't want.

Amazing what people use for test data, if the data is all the
same how would you know whether you have something that
works or not.
 
G

Gord Dibben

Surt

First, select Column then Edit>Go To>Special>Blanks>OK

Edit>Delete>Entire Row.

Now, Data>Filter>Autofilter>Custom>"contains" "fax">OK

Copy the results to a new sheet or area outside the range on the original.

Gord Dibben Excel MVP
 
S

Surt

Thanks to all, I will try now.




Gord Dibben said:
Surt

First, select Column then Edit>Go To>Special>Blanks>OK

Edit>Delete>Entire Row.

Now, Data>Filter>Autofilter>Custom>"contains" "fax">OK

Copy the results to a new sheet or area outside the range on the original.

Gord Dibben Excel MVP
Click to expand...
 
Top