How to paste the 4 lines in a single row in excel?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

"APPASAMY KRISHNA HOSPITAL
DR RAJAKANNAN
OPP VIJAYA NAGAR BUS TERMINAL, 100 FT ROAD
VELACHERY, CHENNAI - 42"

above is the address. i want to paste this in a single row and to filter it
in area wise. please give some idea.
 
Perhaps this:

Sub Test()
Dim arr As Variant
arr = Split(ActiveCell.Value, Chr(10))
ActiveCell.Resize(1, UBound(arr) + 1) = arr
End Sub

Regards,
Greg
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top