Forum Discussion
Excel Dealing with Bible citation reference
Having some difficulties in dealing with Bible Citation Reference (Book Chapter: Verses) in Excel; would appreciate help/comments in dealing with copying the data into Excel and thereafter. C...
Hi Li,
1) Select entire column 2, Ctrl+1, format as text, paste into it after that
2) Like
=A3 & " " & B3
if both columns formatted as text
Thx. It worked.