Transposing - Line Break Cell

[arupghoshal]

601, Khatau Condominium J.M. Mehta Road Nepean Sea Road Mumbai 400006 <tbody> </tbody>	601, Khatau Condominium <tbody> </tbody>	J.M. Mehta Road <tbody> </tbody>	Nepean Sea Road <tbody> </tbody>	Mumbai 400006 <tbody> </tbody>
Gold Croft, 3rd Floor 39, Bhulabhai Desai Road Mumbai 400026 <tbody> </tbody>
B1-209, Ostwal Ornate Jaisal Park Bhayender (E) Mumbai 401105 <tbody> </tbody>

<tbody>
</tbody>

Hello All,

I am a newbie... first post

As you can see from the above table, I have a whole list of addresses which are typed into one cell with line breaks in them.

I want to transpose it into adjacent cells divided by these line breaks as I have tried to demonstrate above. currently, I am having to copy+paste them individually into sepearate columns in the same row.

If someone can help automate it, would be highly obliged.

Thanks and regards,
Arup

 

[arthurbr]

Select the column - Data - Text to columns -select " delimited" check the " Others" checkbox. In the box hit Ctrl+j and then Finish

 

[arupghoshal]

Select the column - Data - Text to columns -select " delimited" check the " Others" checkbox. In the box hit Ctrl+j and then Finish

Wow!

Thanks a ton. You saved me a ton of menial work.... Much appreciated.

Warm Regards,
Arup

 

[arthurbr]

You're welcome