In this case you can just do:

=A1 & CHAR(34)

Hope this helps.

Pete

On Apr 23, 5:24*pm, gueyo wrote:
Sorry to bother you, but what if I have only one measurement.
From here
2-1/2

to here

2-1/2"
--
gueyo



"Glenn" wrote:
gueyo wrote:
This is great. It worked wonderfully. I'm new so I don't know how to rate
this post.???
One more question please. When I do this formula there is not a space between
the "L", "W" *and the *"x" is there a way to add a space? in the formula?

Thank you again.

Should be one already. *If you select and copy the formula from the post, paste
it into Excel and then change the cell reference (the A1) as appropriate, there
will be a space between them. *Always better to copy a formula than trying to
re-type it.

=SUBSTITUTE(SUBSTITUTE(A1," ","""W ",3)," ","""L ",1)&"""H"- Hide quoted text -

- Show quoted text -