I know i sound very NEW to this but I'm not really, just self taught and don't know much!! How can I combine a text column with a number column - i.e. index= text; page no. = number. I need both in one column.
I know i sound very NEW to this but I'm not really, just self taught and don't know much!! How can I combine a text column with a number column - i.e. index= text; page no. = number. I need both in one column.
use concatenate
concatenate(A1,B1)
OR
A1&B1
& is the same as concatenate
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
You are a star Wayne
Thank... so simple, I feel like a real novice.
Wayne - it works - but is there any way you can keep the formatting in the cells (i.e. if I have a word in italics, how do I keep that in italics/bold etc.)?
your welcome, thanks for the rep
you maybe able to use something like
the TEXT() function changes the format of the cell
=TEXT(A1,"#,##0.00") & TEXT(B1,"dd mmm yyyy")
but i dont know how to make it do italics
maybe conditional formatting may help
can you perhaps attach a short sample spreadsheet
I'm off line now for a while , i'm afraid - UK timescales
WIll give it a bash and let you go to sleep
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks