Deleting or splitting data after return carriage

[JohnOB]

We have a spreadsheet which has an address field, the whole address is contained in the field, and in between each part of the address is a symbol which I can only describe as a hollow square, I think this represents a carriage return as this is the format the data would have been in in the system it was taken from.

We only want to show the info before the first symbol, is there anyway we can either delete everything after the first symbol or split the address into seperate fields?

Thanks

Regards,

John

"Stupid isn't not knowing the answer, it's not asking the question

 

[SkipVought]

Hi,

Check out the Split function...

Dim a as variant
a = split([yourcell],vbcr)
for i = 0 to ubound(a)
  msgbox a(i)
next

Skip,

_[red][/red]

 

[JohnOB]

Thanks for the reply, I found the Text to collumns dunction within the Data menue and used this, and it did what was needed!

Thanks

"Stupid isn't not knowing the answer, it's not asking the question