Instead, why dont you use a formula in A1 which will take data from B1. The
existing Data in A1 should be entered another cell. (assuming C1)
So, formula in A1 wld be =C1&" "&B1 . (remove & " " & if u dont want a
space in between.)
Hi Tausif, You may be able to help me with something else. Cell b1 has
address data, eg: 25 Map Rd, Fredsville, 1111. I want to divide this into
individual cells. Hope you can help
Menu Data>Text To Columns, with a delimiter of comma
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.