Merging "space" and character into existing text cell

  • Thread starter Thread starter jazdwit07
  • Start date Start date
J

jazdwit07

I would like to merge text into an existing cell with text. However, I
need to add a space and the dash " - " character to the existing text
before I do this. Is there a formula for this process? Thanks.
 
If your existing text is in A1, your text to add in B1 then in C1 you
could use,

=A1&" - "&B1

This adds the space before the hyphen and after the hyphen.

HTH

Steve
 
If A1=Hello and B1=World
=CONCATENATE(A1,B1)
will give you HelloWorld
and =CONCATENATE(A1," ",B1)
will give you Hello World
 
SteveG said:
If your existing text is in A1, your text to add in B1 then in C1 you
could use,

=A1&" - "&B1

This adds the space before the hyphen and after the hyphen.

HTH

Steve
Click to expand...

Awesome! Thank you!!
 
you would be better off keeping the data in raw format instead of
appending all these spaces.

if you kept this data in a database; it would be simple to set a
formatstring so that you could make the data LOOK like however format
you wanted to.. but you wouldn't need to store the result.

it's like.. having 2 different cars; one with the windows down and one
with the windows up.

excel isn't a real tool; run away while you still can

-Aaron
 
Pay no attention to Aaron.... he and his comments are completely off th
mark and totally useless. For whatever his reason, he is anti-Excel.
The other answers you got are good responses and should do what yo
want
 
Back
Top