View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Carl Carl is offline
external usenet poster
 
Posts: 361
Default Put A Space Between 2 right characters

I have some symbols that look like this

ABC
ABCD
ABCDE

I need a formula that can make this conversion:

A_BC (1 spaces between A and BC)
AB_CD (1 space between AB and CD)
ABC_DE (1 space between ABC and DE)

So I always need the 2 right most characters separated by a space from the
other characters.

I hope I explained this ok.

Thank you in advance.