CODEWITHSUNDEEP
excelexcel-formula
Guy Azouri
Guy Azouri

Reputation: 51

How would I move a plus sign character (+) in excel from beginging of a word to a end?

Transform from:

+WordA +WordB

Transform To:

WordA+ WordB+

What would be the formula?

Upvotes: 1

Views: 66

Answers (2)

teylyn
teylyn

Reputation: 35970

A bit shorter

=SUBSTITUTE(MID(A2,2,999)," +","+ ")&"+"

If the cell is expected to have more than 999 characters, up that number.

Upvotes: 2

ImaginaryHuman072889
ImaginaryHuman072889

Reputation: 5195

Assuming that "+WordA +WordB" is in cell A1, this formula will work:

= SUBSTITUTE(RIGHT(A1,LEN(A1)-1)," +","+ ")&"+"

Upvotes: 1

Related Questions