xcellnoob
Board Regular
- Joined
- Apr 6, 2005
- Messages
- 188
This should be simple for someone I think, but not me....yet.
Let's say that cell A1's formula is
=Inputs!A1
This is copied down, but sometimes the order isn't sequential. So, you could have =Inputs!A15 and the the next cell down is =Inputs!A23. What I want to do without having to go through and manually change everything is to concatenate two cells based on what the first one is already. So, formula in A1 is
=Inputs!A1&" "&Inputs!B1
the second half of that formula, I want something that will look at Inputs!A1 and say...hmmmm...A1; The next part should be B1. Make sense? I was originallly thinking LEN, but I have no idea now.
Also, on an aside, is there a way to bold half of the text?
Thanks for any and all help on this.
Let's say that cell A1's formula is
=Inputs!A1
This is copied down, but sometimes the order isn't sequential. So, you could have =Inputs!A15 and the the next cell down is =Inputs!A23. What I want to do without having to go through and manually change everything is to concatenate two cells based on what the first one is already. So, formula in A1 is
=Inputs!A1&" "&Inputs!B1
the second half of that formula, I want something that will look at Inputs!A1 and say...hmmmm...A1; The next part should be B1. Make sense? I was originallly thinking LEN, but I have no idea now.
Also, on an aside, is there a way to bold half of the text?
Thanks for any and all help on this.