View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tim Tim is offline
external usenet poster
 
Posts: 408
Default Transfer to adjacent columns

Hi

In column A I have a long list that was originally in 4 columns and without
separators for the old columns, ie Basingstoke & Deane £644 £1,140 +77%
The last 3 are all in the same format but the names vary in size.

Is it possible to write a macro to transfer the % to col 4, the 2nd £ amount
to col 3, the 1st £ amount to col 2 and leave the names in col A?

--
TIA
Tim