Merging "space" and character into existing text cell

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.
 
S

SteveG

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
 
S

Some Dude

If A1=Hello and B1=World
=CONCATENATE(A1,B1)
will give you HelloWorld
and =CONCATENATE(A1," ",B1)
will give you Hello World
 
J

jazdwit07

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!!
 
D

dbahooker

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
 
G

greaseman

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
 
Top