Solved: Find values and distribute in cells

[skaswani]

:banghead: :banghead: i m using Excel 2007
i want to write a VBA code
i have branches and branches post entries in core banking system, i have a task to perform, i have to create a MIS, actually required some data to be shifted in various columns
i.e
Posibility 1) SNG#123,Bill#200,Recepit#300
2) SNG123,Bill200,Recepit300
3) SNG123,B200,R300
4) SNG123,Bill200,Recepit300
5) SNG-123,Bill-200,Recepit-300
and if branch put some extra "spaces" it should truncate the spaces
ie.
6) SNG 123,Bill 200,Recepit 300
can i make a code if any of such combination to put or distribute the data into different columns
i.e
if description is in A column , B column should have SNG # , C column should have Bill # , D column should have Reciept #

please assist
Thanks

[Bob Phillips]

I must admit to not fully understanding, can you post an example workbook?

[skaswani]

please check attached file
thanks

[Bob Phillips]

Is this what you want?

[skaswani]

yep, i want to distribute 'A' cell info to other cells

[Bob Phillips]

Sorry, no workbook.

[skaswani]

Thankful

[skaswani]

Dear,

can i arrange the sequence ??
like in last row, the Bill # is not in sequence
can i modify and place the proper value in proper cell??
please assist
THanks

[Bob Phillips]

What do you mean, all in the same column? If so, how would the code know it is out of sequence?

[skaswani]

if i suppose
SNG should be in always displa in D column,
Bill in E
Reciept in F

is this possible?? with IF condition??

[skaswani]

is this possible??