Z
Zippy
Can I have help with a formula to get data from B1 to A1 without losing what
is in A1
is in A1
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
Tausif
I dont think you can !
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.)
HTH,
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.)
HTH,
Z
Zippy
Thank you Tausif, I will give it a go and let you know.
Z
Zippy
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
address data, eg: 25 Map Rd, Fredsville, 1111. I want to divide this into
individual cells. Hope you can help
B
Bob Phillips
Menu Data>Text To Columns, with a delimiter of comma