Excel Help and Problems

[gozalim]

Cool! BTW, for your second argument/parameter, you can just refer to the cell containing the source text. Then you could copy the formula for an entire column.

it's a table so it does go to the whole column. I click the cell it 'takes' that [column title]

[etech0]

it's a table so it does go to the whole column. I click the cell it 'takes' that [column title]

Oh cool! I haven't dealt with tables much. So is @[כרך (א)] the name of your column?

[gozalim]

Oh cool! I haven't dealt with tables much. So is @[כרך (א)] the name of your column?

yes

[etech0]

yes

Nice!

[etech0]

10 Easy Excel Timesavers You Might Have Forgotten

[gozalim]

I'm trying to transpose last name first. like

Code: [Select]

Mr. Donald J. Trump to

Code: [Select]

Trump, Mr. Donald J.seems excel doesn't have a good way to identify "last" though regex should be able to

Code: [Select]

\s\w+\z but not managing to get that fit into the rest of the code
worked something out. replaced \z with $ and used multiple columns to concatenate as needed

[etech0]

I'm trying to transpose last name first. like

Code: [Select]

Mr. Donald J. Trump to

Code: [Select]

Trump, Mr. Donald J.seems excel doesn't have a good way to identify "last" though regex should be able to

Code: [Select]

\s\w+\z but not managing to get that fit into the rest of the code
worked something out. replaced \z with $ and used multiple columns to concatenate as needed

With regex there's pretty much always a way

Code: [Select]

=regexreplace(A2,"(.*) (\w*)","$2, $1")

[yitzf]

I'm trying to transpose last name first. like

Code: [Select]

Mr. Donald J. Trump to

Code: [Select]

Trump, Mr. Donald J.seems excel doesn't have a good way to identify "last" though regex should be able to

Code: [Select]

\s\w+\z but not managing to get that fit into the rest of the code
worked something out. replaced \z with $ and used multiple columns to concatenate as needed

The trick is to concatenate 2 strings together

Code: [Select]

Mr. Donald J. Trump Mr. Donald J. Trump then work from there removing until the second period and the last word etc.

[talmid chuchem]

With regex there's pretty much always a way

Code: [Select]

=regexreplace(A2,"(.*) (\w*)","$2, $1")

The trick is to concatenate 2 strings together

Code: [Select]

Mr. Donald J. Trump Mr. Donald J. Trump then work from there removing until the second period and the last word etc.

Why not just use the right () function, & the select left() - count(right())?

Could be I mentioned the wrong function to count the letters, haven't done it for some time.

[etech0]

Why not just use the right () function, & the select left() - count(right())?

Could be I mentioned the wrong function to count the letters, haven't done it for some time.

I've done it that way, but regex is simpler (once you know how to use it) since you don't need to fuss with nested functions.

[talmid chuchem]

I've done it that way, but regex is simpler (once you know how to use it) since you don't need to fuss with nested functions.

What's regex?

[lubaby]

What's regex?

The past 6+ pages of this thread.

[User6669]

What's regex?

https://en.wikipedia.org/wiki/Regular_expression

[stooges44]

Does anyone know a formula to reverse the order of text within a cell?

EG: the text TCRVO is אברהם in hebrew but I have it written in excel as OVRCT so is there any way to reverse the order?

TIA

[etech0]

Does anyone know a formula to reverse the order of text within a cell?

EG: the text TCRVO is אברהם in hebrew but I have it written in excel as OVRCT so is there any way to reverse the order?

TIA

You can try this: https://superuser.com/questions/121618/any-excel-function-that-will-reverse-a-string

The second answer looks better than the first.