getting data into columns

[William]

I have to get data into columns. the data is in rows for example cell B
(W436), cell B2 (X32), cell B3 (Y4639890), cell B4 (Z58911) cell C
(X453), cell C2 (Z54786), cell C3 (W213), C4 (Y576). I need to get th
data in order. Then into W,X,Y,Z columns so the data all lines up.

Thanks to all,
Willia

 

[Andy B]

Hi

You don't make it clear from your post which values go into which columns.
You'll probably need something including OFFSET() but without understanding
your task it's difficult to advise.

 

[William]

All of the cells data, start with a letter followed with a number. As i
A.2364 B8689 C4.53 D0009. The cells are all over the spreadsheet s
I want a formula to find them I want to find all the cells that star
with A, B, C, or D and put them in A, column B, column C
column or D, column.

Thanks for the help

 

[Andy B]

Hi

If the cells are scattered all over the worksheet you'll need a macro - and
I don't do them! The only alternative would be a lot of sorting and
copying/pasting.