Home |
Search |
Today's Posts |
#2
![]() |
|||
|
|||
![]() Quote:
assuming the input values in column A, try this formula in column B, =reversestring(CONCATENATE(LEFT(reversestring(A2), (IF(ISERROR(SEARCH("""",reversestring(A2),1)),SEAR CH("'",reversestring(A2),1),SEARCH("""",reversestr ing(A2),1)))-1),",",RIGHT(reversestring(A2),LEN(reversestring(A 2))-(IF(ISERROR(SEARCH("""",reversestring(A2),1)),SEAR CH("'",reversestring(A2),1),SEARCH("""",reversestr ing(A2),1))-1)))) and reversestring is a user defined vba function. 'created and edited by bala sesharao Option Explicit Public Function ReverseString(Text As String) ReverseString = StrReverse(Text) End Function all the best.
__________________
Thanks Bala |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can I center a number in "comma" format? | Excel Discussion (Misc queries) | |||
excel 2003: how do I fix: "Style 'Comma' not found" | Excel Worksheet Functions | |||
syntax for "IF" commend to check for multiple empty cells bf comma | Excel Worksheet Functions | |||
Interpreting "comma" where an optional argument is | Excel Worksheet Functions | |||
no comma separator for ="total"&"$ "&sum(a1:a10) | Excel Worksheet Functions |