Hi all,
Before I begin this question, and before you tell me we dont do homework, I would like to state that I have read a few articles, I have tried a couple of functions (=REPLACE, =SUBSTITUTE) but i'm not able to get the reuslts require, I'm new to Excel
Question: Useappropriate text functions to shorten the variable names to something like Arizona Females Young, Arizona Females Old, and Arizona Females All, also is there a way to do it automatically for all variables in 1 function. The screenshot is attached.
It is kind of urgent (I understand people help within their own time).
Thanks in advance.
ami_2
0
Newbie Poster
Recommended Answers
Jump to Postthis link will explain everything on how to use substitute and replace.
https://spreadsheeto.com/replace-and-substitute-text/
Jump to Posti hope this explains.
Jump to Postso thats when u can use the formula =RIGHT(A4, LEN(A4)-2) this will remove the fight 2 letters
All 9 Replies
Gilbertsilva123
30
Light Poster
ami_2
commented:
Hi, thanks for the reply I saw that post =substitute works but what if i want to remove some words from the right and i want to do this for the rest?
+0
Gilbertsilva123
30
Light Poster
ami_2
commented:
I'm sorry, I am trying hard to understand but maybe I'm not getting it, I'll manually edit and show you what i want
+0
Gilbertsilva123
30
Light Poster
ami_2
commented:
Please see the screenshot below
+0
ami_2
0
Newbie Poster
Gilbertsilva123
30
Light Poster
ami_2
commented:
Maybe can you show me an example of the function with the screenshot above?
+0
Gilbertsilva123
30
Light Poster
ami_2
commented:
the reason i am not opting for that option is because i have so many states
+0
Gilbertsilva123
30
Light Poster
ami_2
0
Newbie Poster
Gilbertsilva123
30
Light Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.