abdulhaque
Board Regular
- Joined
- Dec 2, 2015
- Messages
- 63
Hi all,
I'm trying to apply my formula =IF(A2 <> "", LEFT(A2, LEN(A2) - 5), "") & " " & C2 to subsequent rows. I have merged cells in one of the columns, which doesn't work. Image 1 shows how it works currently. The formula is in column B. I need it to work like in image 2. Would I need to use VBA? If so, can I get some help please?
Image 1
https://i.imgsafe.org/3612148e88.png
Image 2
https://i.imgsafe.org/3613b0395b.png
Thanks
I'm trying to apply my formula =IF(A2 <> "", LEFT(A2, LEN(A2) - 5), "") & " " & C2 to subsequent rows. I have merged cells in one of the columns, which doesn't work. Image 1 shows how it works currently. The formula is in column B. I need it to work like in image 2. Would I need to use VBA? If so, can I get some help please?
Image 1
https://i.imgsafe.org/3612148e88.png
Image 2
https://i.imgsafe.org/3613b0395b.png
Thanks