Combining Text From multiple Cells etc

  • Thread starter Thread starter bentley74
  • Start date Start date
B

bentley74

Hi Everyone,
I just found this forum - it looks great!!
I have two questions. First of all, is there some way I could add
number to a word (or words) without spaces. For example, if I have th
phrase: *Eating Goat Cheese* and I wanted to make i
*Eating1Goat1Cheese1*, how would I do so?
I was also wondering how you would simply add the contents of two cell
together (text though, not numbers). So if I had *App* in one cell an
*le-pie* in another cell, how could I make *Apple-pie * in anothe
cell?
Any assistance would be GREATLY appreciated!!!
Thanks

Bentle
 
hi, bentley !
... some way I could add a number to a word (or words) without spaces
... example, if I have the phrase: *Eating Goat Cheese*
... wanted to make it *Eating1Goat1Cheese1*, how would I do so?
Click to expand...

=> try with: =substitute(trim(a1)," ",1)&1
... how... would simply add the contents of two cells together (text though, not numbers)
... if I had *App* in one cell and *le-pie* in another cell, how could I make *Apple-pie * in another cell?
Click to expand...

=> try with: =a1&b1

hth,
hector.
 
Hector,
You are awesome! Thanks so much for the help. Both of those worked
perfectly! :)
Cheers

Bentley
 
FWIW,
To *exactly* duplicate your example, and put the last "1" *INSIDE* the last
asterisk, you would need something like this:

=SUBSTITUTE(SUBSTITUTE(TRIM(A1)," ",1),"*","1*",2)
 
Back
Top